SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Group by on date column to get the total count for month/Year.

user10151069Aug 8 2018 — edited Aug 9 2018

I need help on getting the right out put with the SQL.

Oracle 12c

my code::

select created_date, count(*)
from 
( select
to_char(created_date,'MON') ||'/'|| to_char(created_date, 'YYYY') as
"CREATED_DATE"  from oms_llog)
GROUP BY created_date
ORDER BY 1;

APR/2010 9125

APR/2011 21613

APR/2012 2457

APR/2013 32732

APR/2014 41884

APR/2015 58575

APR/2016 57714

APR/2017 60009

APR/2018 70491

As of now I am getting the output as alphabetical like all April's for all the years then August for all years. How to rewrite the SQL to get the below.

APR/2010 xxxxxx

MAY/2010 xxxx

JUN/2010 xxxxxx

JUL/2010 xxxxxxxx

and so on....

This post has been answered by Sven W. on Aug 9 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2018

Added on Aug 8 2018

14 comments

7,667 views