Pivot SQL SERVER (1 Viewer)

[zezo2021]

Hello

SQL SERVER not access
Table Structure
/
employee name
Department
Salary
City

the table will be full of data


------------------------------
Pivot Table Result will be like this:
department Alabama Arkansas Georgia
IT 100000 50000 6000
Hr 500500 5500 6655


I want to make a pivot in SQL sum salary based on department

What is SQL code

 

[CJ_London]

Have you tried googling?

a quick google returns many links - this one for example

Using PIVOT and UNPIVOT - SQL Server

Transact-SQL reference for PIVOT and UNPIVOT relational operators. Use these operators on SELECT statements to change a table-valued expression into another table.

learn.microsoft.com

 

[June7]

PIVOT in SQLServer requires IN clause. To build the IN array dynamically, review convert SQL output in databricks from long to wide - Stack Overflow

 

[zezo2021]

Have you tried googling?

a quick google returns many links - this one for example

Using PIVOT and UNPIVOT - SQL Server

Transact-SQL reference for PIVOT and UNPIVOT relational operators. Use these operators on SELECT statements to change a table-valued expression into another table.

learn.microsoft.com

SELECT
  [city],
  [HR],
  [IT]
FROM (
  SELECT
    [city],
    [department],
    sum([salary]) as Salary
  FROM dbo.emp
  GROUP BY [city],[department]
) AS myData
PIVOT (
  sum(myData.[Salary])
  FOR myData.department IN ([HR], [IT])
) AS mypivot

the result