咦??
刚才好像答过的呀...SELECT
FLOOR((TO_DAYS(NOW()) - TO_DAYS(`yourdatetime`)) / 10),
COUNT(*)
FROM ...
GROUP BY FLOOR((TO_DAYS(NOW()) - TO_DAYS(`yourdatetime`)) / 10)
刚才好像答过的呀...SELECT
FLOOR((TO_DAYS(NOW()) - TO_DAYS(`yourdatetime`)) / 10),
COUNT(*)
FROM ...
GROUP BY FLOOR((TO_DAYS(NOW()) - TO_DAYS(`yourdatetime`)) / 10)
convert(varchar(10),min(u.range))+'-'+convert(varchar(10),max(u.range)),
count(u.daycount)
from
(select min(datediff(day,timedate,getdate())) as range,
count(timedate) as daycount
from attendance
group by convert(char(10),timedate,20)) u
where u.range > 0
group by ceiling(u.range/10)
妳的這個我試過,結果好像隻能列出一条记录来,我是希望没隔10天做一次汇总to roapzone:
我用的是mysql,不支持子查询的
妳的這個我試過,結果好像隻能列出一条记录来,我是希望没隔10天做一次汇总######你自己的数据不全吧######