Cross tab query

Crosstab query is used for reporting purpose. Using a crosstab query we can convert, row values into column names.

SELECT Yearc,Jan,FEB,MARCH,APRIL,May FROM tbl_Revenue

PIVOT

(

SUM(Revenue)

for Monthc in(Jan,FEB,MARCH,APRIL,May)

)

PIV

Result