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