SQL SELECT TOP Clause

The SELECT TOP clause is used to specify the number of records to return.

Syntax:

SELECT TOP number column_name,....
FROM table_name

OR

SELECT TOP number *
FROM table_name

As you see, we have like this "Candidate" table.

Example:

select Top 3 * from CANDIDATE

Output: