oracle数据库

一、按月分组统计

select to_char(recordDate,'yyyy-mm'),count(recordDate) from admin.event_info group by to_char(recordDate,'yyyy-mm') order by to_char(recordDate,'yyyy-mm');

二、按年分组统计

在这里插入代码片

先排序再分页

SELECT T2.* from(  
SELECT T.*, rownum RN FROM(
      	select ROWGUID, ADDUSERNAME, EVENTNAME, BASEOUNAME, RECEIVEWAY, REPORTDATE, HAPPENDATE, HAPPENADDRESS, DESCRIPTION, TYPEGUID, EVENTLEVEL, STATUS from epointwcoa.EMERG_EVENTINFO 
where TYPEGUID != '值班信息' ORDER BY HAPPENDATE desc
    ) T
	) T2 WHERE RN < 11

附：按实际分组统计：https://www.cnblogs.com/ymj126/p/4501061.html