2.6 Pivot
The SQL Server (Transact-SQL) PIVOT clause allows you to write a cross-tabulation. This means that you can aggregate your results and rotate rows into columns.
QUERY: - SELECT first_column as alias, [pivot_value1], ... [pivot_value_n]
FROM (<source table>) AS <source_table_alias>
PIVOT (aggregate function (<aggregate column>) FOR <pivot column> IN ([pivot_value1] ... [pivot_value_n])) AS T1
EXAMPLE: - SELECT Salary AS TotalSalaryByDept, [30], [45]
FROM (SELECT dept_id, salary FROM employees) AS SourceTable
PIVOT (SUM (salary) FOR dept_id IN ([30], [45])) AS PivotTable;
Last modified: Tuesday, 17 December 2019, 12:35 PM