PIVOT - Understanding the Basics in SQL

preview_player
Показать описание


Рекомендации по теме
Комментарии
Автор

I get the meaning of pivot now, thanks

phongtrangia
Автор

how can I not hard code the quarter options in the pivot column? I don't want to write all options for a column (like Q1, Q2, Q3 etc) since in my case I can have lots of values? thanks! :)

obbjxzw
Автор

It’s basically #matrix manipulation to some extent. But all in all it feels like an aggregation of sorts.

antwanwimberly