Monthly Oracle statement

Oracle Statement of monthly statistics -- Create TABLE TestCTEATE table test (id number not null, modifiedtime date not null) -- SELECT TO_CHAR (T. MODIFIEDTIME, 'yyyy-mm') TIME, COUNT (*) countfrom test t www.2cto.com -- the query condition WHERE TO_CHAR (T. MODIFIEDTIME, 'yyyy') = TO_CHAR (SYSDATE, 'yyyy') group by TO_CHAR (T. MODIFIEDTIME, 'yyyy-mm') -- group order by TO_CHAR (T. MODIFIEDTIME, 'yyyy-mm') asc nulls last -- sort by month -- Note: MODIFIEDTIME is the time field in the TEST table, time type-the above Code can be run directly in the database-if there is a number of fields in the table, to COUNT by day, you can change COUNT (*) to SUM (1) function author guoxuepeng123