Skip to Main Content

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!

I need the query to get the output table format with the help of pivot operator and decode function

User_LC4DAJan 2 2021 — edited Jan 2 2021

IMG-20201230-WA0006 (1).jpg I need the query to get the data or count of account created in between 3 months, 6 months, 9 months and 12 months from the system date or current date separately . I need the query to get the output format table mention above with the use of decode function and pivot operator.

Comments
Post Details
Added on Jan 2 2021
3 comments
312 views