cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Can I use Unpivot clause in databricks SQL ?

youssefmrini
Honored Contributor III
Honored Contributor III

โ€Ž03-03-2023 06:02 AM

 
Labels:
0 Kudos
1 REPLY 1

youssefmrini
Honored Contributor III
Honored Contributor III

โ€Ž03-03-2023 06:02 AM

The UNPIVOT clause is now supported by Databricks SQL. Use the  UNPIVOT

 clause to rotate columns of a table-valued expression into column values https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-unpivot.html

0 Kudos
Announcements
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.