<span style="color: #3c3e41; background-color: #ecf0f3;">Scaz is a place dedicated to providing the content, tools and services you need to learn and succeed in making money online.</span>

Select Top in SQL

The SELECT TOP statement is used to retrieve the top specified number of rows from a table.

Syntax:

SELECT TOP n * FROM tableName

Where n is the number of rows.

Example:

SELECT TOP 2 * FROM EMPLOYEE;

Output:

EMP_ID	EMP_NAME	AGE	SALARY
1	Parbhjot	28	35000
5	Parmender	28	45000

One reply on “Select Top in SQL”

Leave a Reply