Advertisement
Guest User

Untitled

a guest
Jan 20th, 2020
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. WITH tabela AS
  2. (SELECT o.orderid, SUM(quantity*unitPrice) OVER (ORDER BY OrderDate  ROWS unbounded preceding ) wartosc
  3. FROM [ORDER Details] od JOIN orders o ON o.OrderID=od.OrderID
  4. WHERE ShipCountry LIKE 'Germany'
  5. )
  6. SELECT * FROM tabela WHERE wartosc < 4500
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement