4 ms·
It's not nearly as complex as paging, which has a similar purpose of limiting single-query complexity.
by staticassertion 6y ago
It's not nearly as complex as paging, which has a similar purpose of limiting single-query complexity.
- tomnipotent 6y agoAnyone use MSSQL before it got ROW_NUMBER and window functions? Paging was a literal nightmare - if you wanted records 101-110, you had to fetch 1-110 and truncate the first 100 rows yourself (either in the DB via stored procedure or in your app code). I wish LIMIT/OFFSET was SQL ANSI standard.