Oracle SQL query to pivot like excel

Question

I would like pivot using sql query below would be my data format:

I would like my data to be output using oracle sql query to be in the below format:

Could you please assist over here?

if you have 11g, pivot is the thing to use stackoverflow.com/questions/7730111/… oracle.com/technical-resources/articles/database/… blogs.oracle.com/sql/… Also related to using pivot: stackoverflow.com/questions/22103060/… — Jerry Jeremiah
– Jerry Jeremiah, Commented Jul 7, 2021 at 4:45
If you don't have 11g, stackoverflow.com/questions/59245367/… stackoverflow.com/questions/50537526/… — Jerry Jeremiah
– Jerry Jeremiah, Commented Jul 7, 2021 at 4:48

CompEng · Accepted Answer · 2021-07-07 05:12:05Z

8

you can use pivot like this:

SELECT * FROM
(
  SELECT Date,Sales,Count
  FROM your_table
)
PIVOT
(
  sum(Count)
  FOR Date IN ('07-May', '14-May')
) ;

answered Jul 7, 2021 at 5:12

CompEng

7,41618 gold badges77 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I would like to pass the date range rather than mentioning individual dates as that would ensure that i am not missing any date.