Limit and Offset

Syntax

SELECT column_1 [, column_2 ]
FROM table_1
ORDER BY order_column
LIMIT row_count [OFFSET row_offset]

SELECT column_1 [, column_2 ]
FROM table_1
ORDER BY order_column
LIMIT [row_offset,] row_count

Limit could mean “Max number of rows in a table”.

Offset mean pick from row number (not to be confused by primary key value or any field data value)

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents