Skip to content

Instantly share code, notes, and snippets.

@radityopw

radityopw/paging2a.sql

Created February 24, 2016 04:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save radityopw/70f7251a8559a864ea30 to your computer and use it in GitHub Desktop.
Save radityopw/70f7251a8559a864ea30 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
paging2a.sql
SELECT row_number() over(order by orderDate desc, sales.SalesOrderHeader.SalesOrderID desc) as number,Sales.SalesOrderHeader.SalesOrderID, Sales.SalesOrderHeader.OrderDate, Production.Product.ProductNumber, Production.Product.Name,
Sales.SalesOrderDetail.UnitPrice, Sales.SalesOrderDetail.OrderQty, Sales.SalesOrderDetail.UnitPriceDiscount, Sales.SalesOrderDetail.LineTotal
FROM Sales.SalesOrderHeader INNER JOIN
Sales.SalesOrderDetail ON Sales.SalesOrderHeader.SalesOrderID = Sales.SalesOrderDetail.SalesOrderID INNER JOIN
Production.Product ON Sales.SalesOrderDetail.ProductID = Production.Product.ProductID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment