The SELECT TOP statement retrieves records from one or more tables or views and limits the number of records returned based on a fixed value or percentage.

SQL Select TOP syntax:

 SELECT TOP number/percentage

Column1

FROM Table_Name

WHERE condition;

Example:

Lets select the TOP 4 rows from the following table.

Results:

Lets select TOP 50 percent of data.

Results:

Use a where condition to further filter down withing the result set.

Results:

SQL Tutorial