Difference between LIMIT N and FETCH NEXT N ROWS?

5 votes

1 answer

3913 views

The two queries below seem equivalent. Is one better than the other? e.g. in terms of performance.

select * from some_table offset 10 limit 10;

select * from some_table offset 10 fetch next 10 rows;

Asked by James Hiew (183 rep)

Mar 1, 2019, 02:19 PM
Last activity: Jun 2, 2023, 02:24 PM