sql limit and offset code example

Example 1: limit offset

SELECT * FROM artists LIMIT 5 OFFSET 2;

Example 2: sql limit with offset

LIMIT row_count OFFSET offset;

Example 3: limit offset

SELECT * FROM artists LIMIT 5 OFFSET [Number of rows to skip];