Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.24 KB | None | 0 0
  1. USE [Northwind_mc]
  2.  
  3. SELECT OrderID AS OrderNumber,
  4.     UnitPrice AS [Price per Unit],
  5.     (UnitPrice * Quantity) AS Total
  6.  
  7. FROM [Order Details]
  8. WHERE (UnitPrice * Quantity) > 1000
  9. ORDER BY Total
  10.     OFFSET 10 ROWS
  11.     FETCH NEXT 5 ROWS ONLY;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement