Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Podkategoria, Produkt,
- Sum(Kwota) OVER(PARTITION BY Podkategoria, Produkt) AS "Kwota",
- Sum(Kwota) OVER (PARTITION BY Podkategoria ORDER BY Produkt ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS "Suma narastająco"
- FROM(
- SELECT PSC.Name AS "Podkategoria", P.Name AS "Produkt", Sum(SOD.LineTotal) AS "Kwota"
- --Sum(SOD.LineTotal) OVER(PARTITION BY PSC.Name, P.Name) AS "Kwota",
- --Sum(SOD.LineTotal) OVER (PARTITION BY PSC.Name, P.Name ORDER BY P.Name ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS "Suma narastająco"
- FROM Sales.SalesOrderDetail AS "SOD"
- RIGHT JOIN Production.Product AS "P" ON(SOD.ProductID = P.ProductID)
- JOIN Production.ProductSubcategory AS "PSC" ON(P.ProductSubcategoryID = PSC.ProductSubcategoryID)
- GROUP BY P.Name, PSC.Name) AS "t"
- --ORDER BY PSC.Name, Sum(SOD.LineTotal);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement