SELECT
TO_NUMBER(TO_CHAR (T.POL_START_DATE, 'mm'))getmonth,
COUNT (T.POL_CODE)TOTAL
FROM
IPR_POLICY T
GROUP BY
TO_CHAR (T.POL_START_DATE, 'mm') ORDER BY getmonth
SELECT
TO_NUMBER(TO_CHAR (T.POL_START_DATE, 'mm'))getmonth,
COUNT (T.POL_CODE)TOTAL
FROM
IPR_POLICY T
GROUP BY
TO_CHAR (T.POL_START_DATE, 'mm') ORDER BY getmonth
转载于:https://my.oschina.net/u/2822116/blog/703458