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

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

thanks

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

Thanks a lot for this efforts❤❤

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

Thanks mam very helpful

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

We can use pivot also?

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.

Thanks

thanks

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

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

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

very helpful video.

this is outstandingly perfect

Can u do it with multiple rows?

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

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