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.