Forum Stats

  • 3,770,766 Users
  • 2,253,163 Discussions
  • 7,875,581 Comments

Discussions

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

User_LC4DA
User_LC4DA Member Posts: 2
edited Jan 2, 2021 5:36PM in SQL & PL/SQL

 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.

Answers