Oracle按周，按月统计
//按月统计
select trunc(ADDTIME,'mm'),count(distinct phone) as phone from ACCESSLOGS group by trunc(ADDTIME,'mm');
select to_char(ADDTIME,'yyyy-mm'),count(distinct phone) as phone from ACCESSLOGS group
原创
2014-02-24 16:51:47 ·
961 阅读 ·
0 评论
关注
分享
扫一扫