PostgreSQL → SQL Server

LIMIT and OFFSET Equivalent in SQL Server (Pagination)

PostgreSQL LIMIT 10 OFFSET 50 becomes OFFSET/FETCH in SQL Server 2012+.

PostgreSQL uses LIMIT and OFFSET at the end of SELECT. SQL Server (2012+) requires ORDER BY followed by OFFSET ... ROWS FETCH NEXT ... ROWS ONLY.

Comparison

PostgreSQL

SELECT * FROM orders ORDER BY id LIMIT 10 OFFSET 50;

SQL Server

SELECT * FROM orders
ORDER BY id
OFFSET 50 ROWS FETCH NEXT 10 ROWS ONLY;

Broken pagination is a silent API bug. Validate every SELECT with LIMIT in diagnostics before deploy.