paging3.sql

SELECT        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
order by orderDate desc, SalesOrderID desc
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY;