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 -
