|
The following
T-SQL database script in Query Editor demonstrates the use of the TOP function to get both TOP and BOTTOM of a table in one query.
USE AdventureWorks;
GO
SELECT OrderDate = convert(varchar, OrderDate,111)
, sod.*
FROM Sales.SalesOrderDetail sod
INNER JOIN Sales.SalesOrderHeader soh
ON soh.SalesOrderID = sod.SalesOrderID
WHERE SalesOrderDetailID IN (
SELECT TOP 5 SalesOrderDetailID
FROM Sales.SalesOrderDetail
ORDER BY SalesOrderDetailID)
OR
-- Descending sort will give the BOTTOM even though TOP is used
SalesOrderDetailID IN (
SELECT TOP 5 SalesOrderDetailID
FROM Sales.SalesOrderDetail
ORDER BY SalesOrderDetailID DESC)
ORDER BY SalesOrderID
GO
|