SQL clause to limit number of returned rows
The LIMIT clause is used to specify a maximum of rows to be returned in a SELECT query. The various SQL dialects use different syntax elements for that purpose. LIMIT x OFFSET y, is understood by MySQL, PostgreSQL, SQLite and some others RDBMS.
Example:
SELECT * FROM tbl LIMIT 10;The SQL:2008 standard defines:
FETCH FIRST n ROWS ONLY
SQL Server uses TOP n, Oracle its rownum feature.
There is a comprehensive list on Wikipedia.
