Paginating Your Way Through Large Datasets: Exploring LIMIT and OFFSET in SQLite
Used to restrict the number of rows returned by a SELECT query.Syntax: SELECT . .. FROM . .. LIMIT numberExample: SELECT * FROM customers LIMIT 10 (retrieves the first 10 rows)