Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH tabela AS
- (SELECT o.orderid, SUM(quantity*unitPrice) OVER (ORDER BY OrderDate ROWS unbounded preceding ) wartosc
- FROM [ORDER Details] od JOIN orders o ON o.OrderID=od.OrderID
- WHERE ShipCountry LIKE 'Germany'
- )
- SELECT * FROM tabela WHERE wartosc < 4500
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement