SQL LIMIT Clause ¶

The limit cause can be used to skip the first k results, or/and define the max number of results n.

[...] LIMIT n; -- return up to n records
[...] LIMIT k, n; -- skip k records, returns up to n records
[...] LIMIT 0, 1; -- up to one record
[...] LIMIT 1, 1; -- up to one record, skip the first record