oracle按天去重按月统计sql select substr(day,1,6) as 月份,sum(daysum) as 用户数 from (select to_char(date,’yyyymmdd’) as day,count(DISTINCT an_id) as daysum from ANONYMOUS group by to_char(date,’yyyymmdd’)) group by substr(day,1,6)
残忍的人,选择伤害别人;善良的人,选择伤害自己