SQL PIVOT & UNPIVOT simple explanation

SQL pivot and unpivot easy and simple expression

[@VinothrajK-y8n]

Thanks for the video

[@ahmadyano123]

Thank you so much! You explained better than every instructor and course paper I found on the internet and offline as well! You're a hero.

[@snehasishbehera8447]

Thank you so much for explaining this topic so well.

[@Rasa_Krishna27]

its good ,can you please add two more columns like profit and lose and make a pivot with all columns avaliable in the table .i want one column with count ,other with max and another with sum .can you please do it ,i have such requirements.

[@gurusekharreddy6915]

I have to do dynamically. How can i do

[@syamprasadp1994]

madam in from clause we have to write select * is complusory or we can write column names

[@lagudaadeyemi8359]

why do we have to put [2019] , and not just 2019?

[@snehasishbehera8447]

because it is a row level data so write it in [ ]

[@subhashinib7608]

Your voice is not at all clear