Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- zad 4
- -- 4.1
- -- bez pivota
- SELECT YEAR(OrderDate) "Rok",
- SUM(IIF(MONTH(OrderDate) = 1, 1, 0)) [1],
- SUM(IIF(MONTH(OrderDate) = 2, 1, 0)) [2],
- SUM(IIF(MONTH(OrderDate) = 3, 1, 0)) [3],
- SUM(IIF(MONTH(OrderDate) = 4, 1, 0)) [4],
- SUM(IIF(MONTH(OrderDate) = 5, 1, 0)) [5],
- SUM(IIF(MONTH(OrderDate) = 6, 1, 0)) [6],
- SUM(IIF(MONTH(OrderDate) = 7, 1, 0)) [7],
- SUM(IIF(MONTH(OrderDate) = 8, 1, 0)) [8],
- SUM(IIF(MONTH(OrderDate) = 9, 1, 0)) [9],
- SUM(IIF(MONTH(OrderDate) = 10, 1, 0)) [10],
- SUM(IIF(MONTH(OrderDate) = 11, 1, 0)) [11],
- SUM(IIF(MONTH(OrderDate) = 12, 1, 0)) [12]
- FROM Sales.SalesOrderHeader
- GROUP BY YEAR(OrderDate)
- ORDER BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement