Articles/SQL

OFFSET in MySQL — How It Works

What the MySQL OFFSET function does, with an example.

Published October 22, 2026

OFFSET skips a specified number of rows before starting to return results, typically used with LIMIT for pagination.

Key points

  • Part of standard SQL functions available in MySQL for working with query results

Example

SELECT * FROM posts LIMIT 10 OFFSET 20;
More SQL articles