1. Select Top
SQL provides several ways to limit the number of rows returned in a query result, including:
Syntax:
|
1 2 |
SELECT TOP N [column1, column2, ...] FROM table_name; |
example:
|
1 2 3 |
SELECT TOP 3 * FROM cars; |
2. LIMIT Clause (MySQL, PostgreSQL)
syntax:
|
1 2 3 |
SELECT [column1, column2, ...] FROM table_name LIMIT N; |
example:
|
1 2 3 |
SELECT * FROM employees LIMIT 3; |
3. FETCH FIRST Clause (DB2, Oracle)
syntax:
|
1 2 3 |
SELECT [column1, column2, ...] FROM table_name FETCH FIRST N ROWS ONLY; |
example:
|
1 2 3 |
SELECT * FROM cars FETCH FIRST 3 ROWS ONLY; |
4. ROWNUM Clause (Oracle)
syntax:
SELECT [column1, column2, …]
FROM (
SELECT [column1, column2, …], ROWNUM as row_number
FROM table_name
)
WHERE row_number <= N;
example:
|
1 2 3 4 5 6 7 |
SELECT * FROM ( SELECT *, ROWNUM as row_number FROM cars ) WHERE row_number <= 3; |