query with limit and offset code example

Example: limit offset

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