I have data in a table as seen below:
MONTH VALUE 1 100 2 200 3 300 4 400 5 500 6 600
I want to write a SQL query so that result is given as below:
MONTH_JAN MONTH_FEB MONTH_MAR MONTH_APR MONTH_MAY MONTH_JUN 100 200 300 400 500 600