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

[@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! imp.i384100.net/Ke51on

[@marshalljackson1385]

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

[@LearnatKnowstar]

Thank you

[@erikashantini8529]

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

[@LearnatKnowstar]

Thanks a lot!

[@gbagba81]

this is outstandingly perfect

[@LearnatKnowstar]

Thank you so much.

[@roshninirmolia7440]

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

[@LearnatKnowstar]

Glad it helped!

[@gulahmadfaizi6572]

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

[@LearnatKnowstar]

Thanks so much!

[@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!

[@shreddersengupta7384]

This is great! keep up the good work.

[@LearnatKnowstar]

Thank you

[@8886naveen]

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

[@LearnatKnowstar]

Glad it helped

[@shubhammalviya3001]

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

[@bonghahn6610]

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.

[@kristyowens2284]

very nicely explained.

[@LearnatKnowstar]

Thank you

[@sourabhpatel3834]

We can use pivot also?

[@pritichauhan463]

Thanks a lot for this efforts❤❤

[@LearnatKnowstar]

Thank you

[@master_persi]

very helpful video.

[@LearnatKnowstar]

Thank you so much.

[@engp8691]

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

[@LearnatKnowstar]

We will try to upload the sqls which can be used for practice.

[@ahmadiyorismatov1971]

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

[@widzewisze8475]

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

[@rapthaduchandra1113]

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

[@chetankulkarni5]

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.

[@LearnatKnowstar]

Thanks for your suggestions. Will plan videos soon

[@farooqkota8692]

Thanks mam very helpful

[@LearnatKnowstar]

Thank You!

[@akhildas3743]

Can u do it with multiple rows?

[@ДмитрийСтрекалов-т7в]

declare @cmd varchar(max) = 'select id' select @cmd += replace(char(10)+',max(iif(name=''@name'',val,null)) @name','@name',name) from (select distinct Name from temp_t1) t set @cmd += ' from temp_t1 group by id' print @cmd exec(@cmd)

[@adarshsonare9049]

Thanks

[@LearnatKnowstar]

Glad it was helpful.

[@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 ''"

[@fernandosouza9678]

thanks

[@ramzamthel8014]

thanks

[@LearnatKnowstar]

Thank You!