OFFSET ... FETCH (SQL Standard)
OFFSET ... FETCH (SQL Standard) is a SQL clause in the SELECT Queries category. SQL standard pagination syntax (ISO/ANSI). Alternative to LIMIT/OFFSET. Used in SQL Server, Oracle 12c+, PostgreSQL. The syntax is ORDER BY column OFFSET skip_count ROWS FETCH NEXT take_count ROWS ONLY;. It returns paginated result set. A typical example: SELECT name, salary FROM employees ORDER BY salary DESC OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY; -- Skip 10 rows, return next 5 (page 3 of 5) -- SQL Server: OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY -- Oracle 12c+: OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY A close relative is SELECT, which retrieves data from a table. The most fundamental SQL statement. A close relative is SELECT *, which selects all columns from a table. A close relative is SELECT DISTINCT, which returns only distinct (unique) values from the specified columns.