1.查看 十二个月的用户注册总数
select count(userid),trunc(regdate,'month') from user where to_char(regdate,'yyyy')=':years' group by trunc(regdate,'month')
1.查看 十二个月的用户注册总数
select count(userid),trunc(regdate,'month') from user where to_char(regdate,'yyyy')=':years' group by trunc(regdate,'month')