Blog
SQLite LIMIT Clause
SQLite LIMIT Clause
The SQLite LIMIT clause limits the number of rows the SELECT statement returns. This is useful when we query a large table.
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/