Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Department revenue pivot
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' SELECT department, SUM(CASE WHEN MONTH='Jan' THEN revenue ELSE 0 END) AS Jan_Revenue, SUM(CASE WHEN MONTH='Feb' THEN revenue ELSE 0 END) AS Feb_Revenue, ... FROM department GROUP BY department ORDER BY department
run
|
edit
|
history
|
help
0
TSQL - Logic driven by two most recent rows
Cinema latinoamericano
customers
Names
viernes_ alumnos
SO_20171230_SqlServer
it
SQL basics(Data Definition Language)
Pivot and Unpivot
b