select DISTINCT to_char(sendtime,'YYYY-MM-DD') as datenumber ,count(*) as countnumber from cjjb_mobile_revtable where rownum < 51 and rownum >= 1 GROUP BY to_char(sendtime,'YYYY-MM-DD') order by ID desc。目的是通过提取数据库表中的日期进行统计个数,这个语句怎么改呀?急急急,在线等待!
调试欢乐多
from
(
select DISTINCT to_char(sendtime,'YYYY-MM-DD') as datenumber ,count(*) as countnumber from cjjb_mobile_revtable GROUP BY to_char(sendtime,'YYYY-MM-DD') order by ID desc
) where rownum < 51