SQL Select Top Clause

The SQL select top clause is used to return the number of records. It is very helpful when we want to fetch the record from a very large table that contains thousands of records.

Example –

Firstly we create a table with name “emp”-

 Select top 2 * from emp

Output - 

SQL Select TOP PERCENT Example -

Select top 50 percent * from emp

Output -