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
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