sql按天分组

sql按天分组,这都不会 晕!!!!!!!

 

select to_char(createtime,'yyyymmdd'),count(1) from os_user_config_0705 group by to_char(createtime,'yyyymmdd') order by 1;

 

posted @ 2016-07-06 17:31  yy23  阅读(6464)  评论(0编辑  收藏  举报