SELECT
To_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'yyyy) work alone,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '01, jh, 0))) as January,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '02', jh, 0))) as February,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '03, jh, 0))) as of march,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '04, jh, 0))) as April,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '05, jh, 0))) as may,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '06, jh, 0))) as of June,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM), and' 07, jh, 0))) as July,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '08', jh, 0))) as in August,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '09, jh, 0))) as September,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '10', jh, 0))) as of October,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '11', jh, 0))) as of November,
To_char (SUM (DECODE (to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'MM'), '12, jh, 0))) as December,
The sum (jh) subtotal
The from
(

The select to_char (to_date (C536870974, 'yyyy - - dd HH: MM mi: ss'), 'yyyymmdd') yyyymmdd, COUNT (C536870917) from jh t96159
Group by C536870974

) e
Group by to_char (to_date (YYYYMMDD, 'MM - dd yyyy -'), 'yyyy)

CodePudding user response:

6666666666666