Oracle statistics statement by quarter

Oracle statistics statement by quarter
the
–Create table Test
CTEATE TABLE TEST(
ID NUMBER NOT NULL,
MODIFIEDTIME DATE NOT NULL
)
–Statistics by quarter
SELECT TO_CHAR(T.MODIFIEDTIME,'YYYY') YEAR,TO_CHAR(T.MODIFIEDTIME,'Q') TIME,COUNT(*) COUNT www.2cto.com 
FROM TEST T
–You can add query conditions here WHERE TO_CHAR(T.MODIFIEDTIME,'YYYY') = TO_CHAR(SYSDATE,'YYYY')
GROUP BY TO_CHAR(T.MODIFIEDTIME,'Q'),TO_CHAR(T.MODIFIEDTIME,'YYYY') –group by quarter of each year
ORDER BY TO_CHAR(T.MODIFIEDTIME,'YYYY'),TO_CHAR(T.MODIFIEDTIME,'Q') ASC NULLS LAST –Sort according to the quarter of each year
the
— Note: MODIFIEDTIME is the time field in the table TEST, the time type
–The above code can be run directly in the database
–If there is a quantity field in the table, if you want to count the quantity by day, you can change COUNT(*) to SUM(1) function
the
the
Author guoxuepeng123