SQL | Pivot | Case | Convert data from Rows to Columns

This video is part of the series on scenario based SQL Query Interview questions.

This discusses how you can use a SQL Query to convert data from rows to columns / pivot data.

This is Part 1 of the video and discusses the first approach using the CASE statement.

Below is the link for Part 2 of the video which discusses the SQL PIVOT function to achieve the same objective.

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Practice SQL Queries on Your Browser through Interactive Courses -

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[LearnatKnowstar]

Register at the below link to get US $100 off for Coursera Plus membership between Sep 8 - Sep 29, 2022.
The Coursera Plus membership gets you access to unlimited courses and unlimited certifications!

[marshalljackson]

Thank you providing multiple methods of pivoting columns into rows. Very informative and useful.

[erikashantini]

Thank you very much for this :) It saved me from a job request today big time!! Thank you!

[LearnatKnowstar]

Thank you for sending the SQL Queries that you were asked in interviews.
We will be covering most of them in future videos.


If you wish to share more such queries, then you can send them to our email or put them down in the comments below!

[gulahmadfaizi]

Thanks A lot Sister, Please keep it up. repsect from Afghanistan.

[roshninirmolia]

This is exactly what I was searching for. You made my day thank you so much

[bonghahn]

Hi Your Case Section on tables is great. The issue I have is when I want to show filtered records only, for example I have several forms and I wnat to only show form 5 entries. I tried WHERE formid=5 but i get error message. Hope my question makes sense.

[shubhammalviya]

Your voice is very sweet, Thanks for the explanation. Above approach is working on SQL server but not on Mysql please help.

[naveen]

Very Informative. It helped me to solve my project requirement🤩

[chetankulkarni]

Please explain real time scenarios while loading the data to a table. Ex. Will the job fail if an application layer is inserting the data and the same table is being read by other job.

[ahmadiyorismatov]

what is data type of [value] column . there is mixed number and letters

[widzewisze]

hi ; thanks for your video, but can you add another one about many rows ?, i need help about n rows?

[rapthaduchandra]

Hi Team,
Can you please send me the table syntaxes for these tables.

[engp]

Can you provide a download of the Database you used for your videos. Thank you so much.

[Tejailab]

please provide data sets for all related videso

[klavesin]

Won't work if a value is NULL. Better use "else Null" instead of "else ''"