08.14.07

Transact-SQL Reserved Keyword – Top

Posted in Code Speak at 11:39 pm by codetiger

Return only the top 10 rows of a query

SELECT TOP 10 OrderID, CustomerID, EmployeeID, OrderDate
FROM dbo.Orders
WHERE EmployeeID = 5
ORDER BY OrderDate