LIMIT clause

The LIMIT clause limits the number of rows returned by a query to a specified non-negative integer.

• Syntax
• Examples

Syntax

SELECT_clause FROM_clause [WHERE_clause] [GROUP_BY_clause] [ORDER_BY_clause] LIMIT <N>

Examples

Limit results to a maximum of five rows

SELECT  "water_level","location", "time" FROM  "h2o_feet" LIMIT  5

Sort and limit results

Use the ORDER BY and LIMIT clauses to first sort results by specified columns, then limit the sorted results by a specified number.

SELECT  "water_level", "location", "time" FROM  "h2o_feet" ORDER BY  "water_level" DESC LIMIT  3