SQLite LIMIT Clause
Overview
The SQLite LIMIT clause limits the number of rows the SELECT statement returns. This is useful when we query a large table.
SQLite LIMIT Clause
Syntax
The general syntax of the LIMIT clause is as follows:
SELECT *
FROM table_name
LIMIT <no of rows>
or
SELECT column1, column2,…, columnN
FROM table_name
LIMIT <no of rows>
—
SQLite Tutorials
SQLite tutorials on this website:
https://www.testingdocs.com/sqlite-database-tutorials/
For more information on SQLite, visit the official website:
