Oracle按季度统计语句

--创建表 Test

CTEATE TABLE TEST(

ID  NUMBER NOT NULL,

MODIFIEDTIME  DATE NOT NULL

)

--按季度统计

SELECT TO_CHAR(T.MODIFIEDTIME,'YYYY') YEAR,TO_CHAR(T.MODIFIEDTIME,'Q') TIME,COUNT(*) COUNT   

FROM TEST T

--这里可加查询条件 WHERE TO_CHAR(T.MODIFIEDTIME,'YYYY') = TO_CHAR(SYSDATE,'YYYY')

GROUP BY TO_CHAR(T.MODIFIEDTIME,'Q'),TO_CHAR(T.MODIFIEDTIME,'YYYY')   --根据每年季度来分组

ORDER BY TO_CHAR(T.MODIFIEDTIME,'YYYY'),TO_CHAR(T.MODIFIEDTIME,'Q') ASC NULLS  LAST  --根据每年季度来排序