怎么判断查询结果中日期的连续

2012-05-22

如何判断查询结果中日期的连续namedate(?)尾人柱力2012-02-18(?)尾人柱力2012-02-19(?)尾人

如何判断查询结果中日期的连续
"name""date"
"(?)尾人柱力""2012-02-18"
"(?)尾人柱力""2012-02-19"
"(?)尾人柱力""2012-02-20"
"(?)尾人柱力""2012-02-21"
"(?)尾人柱力""2012-02-22"
"(?)尾人柱力""2012-02-23"
"(?)尾人柱力""2012-02-24"
"(眞愛苛笶.""2012-02-18"
".惹关关""2012-02-18"
".苍井空.""2012-02-18"
".苍井空.""2012-02-19"
".苍井空.""2012-02-20"
".苍井空.""2012-02-21"
".苍井空.""2012-02-22"
".苍井空.""2012-02-23"
".苍井空.""2012-02-24"
"//。紀寧ggく""2012-02-18"
"//。紀寧ggく""2012-02-21"
"00xx111""2012-02-18"
"00xx111""2012-02-19"

SQL code

select name,date(time) date from logdb.player_log3 where time BETWEEN '2012-02-18' and '2012-02-25' group by name,date limit 20;

取出日期之后如何判断每个玩家最大的连续天数，求教！

[解决办法]

SQL code

GOIF OBJECT_ID('TBL')IS NOT NULLDROP TABLE TBLGOCREATE TABLE TBL(日期 DATE)GOINSERT TBLSELECT '2012-03-01' UNION ALLSELECT '2012-03-31'--利用递归实现输出三月份的所有日期：godeclare @date dateselect @date=MAX(日期) from tbl;with tas(select * from tblunion allselect dateadd(dd,1,a.日期) from t awhere not exists(select * from tbl bwhere b.日期=DATEADD(DD,1,a.日期))and a.日期<@date)select *from t order by 日期/*日期2012-03-012012-03-022012-03-032012-03-042012-03-052012-03-062012-03-072012-03-082012-03-092012-03-102012-03-112012-03-122012-03-132012-03-142012-03-152012-03-162012-03-172012-03-182012-03-192012-03-202012-03-212012-03-222012-03-232012-03-242012-03-252012-03-262012-03-272012-03-282012-03-292012-03-302012-03-31*/查询出不存在的日期和原有的日期，自动生成三月份的所有日期参考

热点排行

SQL Server

怎么判断查询结果中日期的连续