How to convert ROWS into COLUMNS in SQL without using Pivot table

Hi, In this video we've discussed how to convert ROWS into COLUMNS in SQL without using Pivot table, this is an important sql concept to master.
SQL Convert Rows to Columns and Columns to Rows without using pivot table.
SQL Query - Convert data from Rows to Columns
✨Link to purchase my e-book: imojo.in/rkajq9
This e-book will prove to be one of the best decisions of your life!
✨Join this channel to get access to perks:
/ @crackconcepts
✨Work related mails can be sent on [e-mail]
✨If you appreciate my work and would like to donate to support our channel, you can do so here : paypal.me/sadi...
✨Please like, share, subscribe and comment down. It would make my day :)
Thank you, have a nice day!

[@TahirBhai]

Interesting topic, thank you for sharing it with us.

[@MyTradingSecrets]

Good and simple Explanation

[@logeshn009]

Thanks really helpful 🙌❤️

[@lifehacksbyharshal]

THANKS

[@KevinAlvares_Data]

Very helpful tutorial! What approach would you take if you had a large number of products in your table?

[@Databyte21]

Same question asked to me by CitiusTch

[@divyadubey6679]

Thank u so much for this video
Please provide link ( using pivot) and window function.

[@sandeephanda8001]

In the example you have summed to reduce multiple rows into one. If the last column is a date, or a text field, how to reduce to one row?

[@omkarmore7017]

How can we aggregate non numeric with nulls.
We can convert nulls to string but what if there is date datatype