SQL LIMIT
The SQL LIMIT command allows you to set a limit on how many rows you want returned.
PostgreSQL, MySQL
SQL Server
Oracle
SELECT
*
FROM
tenants
LIMIT
2;
tenants table
| id | name |
|---|---|
| 1 | Albert |
| 2 | Marie |
| 3 | Jose |
| 4 | Terrell |
Query results
| id | name |
|---|---|
| 1 | Albert |
| 2 | Marie |