DEV Community

How to rotate data using Pivot & Unpivot operators

Olesia Dudareva on May 15, 2023

PIVOT and UNPIVOT are Transact-SQL operators which are used for transforming rows to columns and vice versa. These operators were added to SQL Serv...
Collapse
 
rozhnev profile image
Slava Rozhnev

Nice! Tested on SQLize.online

Collapse
 
notte profile image
Olesia Dudareva

Thanks! Your link is quite interesting. So many variants of databases. On my computer it works not very fast but results look pretty good. I should admit, it is very useful tool!