Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [Northwind_mc]
- SELECT OrderID AS OrderNumber,
- UnitPrice AS [Price per Unit],
- (UnitPrice * Quantity) AS Total
- FROM [Order Details]
- WHERE (UnitPrice * Quantity) > 1000
- ORDER BY Total
- OFFSET 10 ROWS
- FETCH NEXT 5 ROWS ONLY;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement