Skip to content
Advertisement

Transpose in ORACLE SQL (Convert 6 columns into 3 Columns)

I’ve an output like the below.

enter image description here

I want that to be converted into the below

enter image description here

Where ID is the count of TOTAL, HIGH, SENT, WAITING, DATE. I have been contemplating for a while and couldn’t get what I want. Can any one please help in ORACLE SQL?

Thanks in advance.

Advertisement

Answer

Here’s one option:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement