intermediate pagination SQL Server PostgreSQL
Include All Tied Rows When Limiting Results With WITH TIES
Add `WITH TIES` when limiting rows to also return every row that shares the same ORDER BY value as the last included row, preventing arbitrary tie-breaking at the result boundary.