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
Insert index into Temporary Table
archu
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
practice sql_12AUG
BRYAN
Performance test - select vs while - Get all days between two dates.
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers. #5
HOTEL
MyWall
Display Multiple Rows as a single Line