The LIMIT .. OFFSET Clause

The LIMIT clause is used to limit the data amount returned by the SELECT statement and the OFFSET clause is used to return rows starting from the next row to the given value.

SQL	SqliteMagic
SELECT * FROM AUTHOR LIMIT 2 OFFSET 1;	import static com.siimkinks.sqlitemagic.AuthorTable.AUTHOR; List<Author> authors = Select .from(AUTHOR) .limit(2) .offset(1) .execute();

See Next

• TheSELECT Clause
• The FROM Clause
• The JOIN Clause
• The WHERE Clause
• The GROUP BY Clause
• The HAVING Clause
• The ORDER BY Clause
• Generated Tables
• Aliased Tables
• Nested Selects
• Column Expressions
• Conditional Expressions