sql按天分组

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

 

sql按天分组

标签：