TOP

SQL Server

Example

SELECT TOP 3 * FROM Orders;

Output

OrderID | CustomerID | EmployeeID | OrderDate
---------------------------------------------------
10248   | 90         | 5          |  1996-07-04
10249   | 81         | 6          |  1996-07-05
10250   | 34         | 4          |  1996-07-08

Explanation

The TOP keyword is used to specify the number of records to return from top of the dataset. In the given example, the first 3 records from the Orders table are returned.