<-- Chapter 21: SQL Injection

SQL Select Top clause is used to retrieve TOP N number of Records or X percent of Records from database table.

Note: All database systems does not support the SELECT TOP clause.

Lets see an example from the below table "employees" :-

SELECT TOP SQL syntax :-

Following is an example of SQL Server

SELECT TOP 3 *
FROM `employees`;

Now run the above SQL query, we will see the output below :-

Now we can see here, Top 3 Rows are displayed.

SELECT TOP PERCENT SQL syntax :-

Following is an example of MYSQL

SELECT *
FROM `employees`
LIMIT 3;

Now run the above SQL query, we will see the output below :-

Now we can see here, Top 3 Rows are displayed.

If we are using ORACLE, Following is an example :-

SELECT * 
FROM `employees`
WHERE ROWNUM <= 3;

Now run the above SQL query, we will see the output below :-

Now we can see here, Top 3 Rows are displayed.

SELECT TOP 50 PERCENT * 
FROM `employees`;

Now run the above SQL query, we will see the output below :-

Now we can see here, Top 50 Percent Rows are displayed.