Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --zamowienie klienta o najmniejszej ilosci produktow
- select TOP 1 @idzamowienia= od.OrderID from Orders o
- join [Order Details] od on od.OrderID=o.OrderID
- where o.CustomerID=@idklienta
- group by od.OrderID
- order by COUNT(*) asc
- A nie powinno być order by SUM(od.Quantity) asc?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement