CodesJava

Easy learning with example program codes

SQL SELECT TOP

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

 
Next Topic: SQL SELECT IN Operator with example.
Previous Topic: SQL DISTINCT keyword with example.

 

Please follow and like us:
error
Posted in SQL   








Copyright © 2019 CodesJava DMCA.com Protection Status