SQLite LIMIT clause

In SQLite the LIMIT clause is used as part of SQLite SELECT statements. The LIMIT clause is optional. It limits the number of rows returned by the SELECT query.

The syntax is as shown:

SELECT

                colname1, colname2

FROM

                tablename

LIMIT rowcount;

Here is an example that demonstrates this:

SELECT

                name,

                location,

                revenue

FROM

                customers
LIMIT 100;

This returns max 100 rows from the customers table, containing name, location and revenue of customers.