#offset-fetch

Configuring OFFSET‑FETCH pagination in Azure SQL Database when Row‑Level Security is enabled

When using Azure SQL Database to paginate a large result set with the OFFSET‑FETCH clause, you may also have Row‑Level Security (RLS) policies that filter rows before the offset is applied. The goal is to retrieve a predictable page size (e.g., 20 rows) regardless of how many rows are hidden by RLS, while keeping the query plan efficient across different off

row-level-securityazure-sql-databaseazuresqldatabaseTasadduq Burneyowner23.5K rep · 09 May 2026, 22:25 UTC