SQL Pivot Table | SQL For Data Analysts

preview_player
Показать описание
I am going to show you how to quickly pivot your data in with the PIVOT function. This will essentially allow you to create a Pivot Table with your SQL query and indicate the aggregation type. Also, we will set an index for our pivot table.

#sql
#dataanalysis
#datascience
#sqlinterview

Learn and Practide SQL coding online at DataCamp, check out my affiliate link:

Background Music
________________________________________________________________
Creative Commons / Attribution 3.0 Unported License (CC BY 3.0)
Рекомендации по теме
Комментарии
Автор

How can you make it dynamic. The prospect of hard coding columns is ridiculous

darrylw
join shbcf.ru