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
azuresqldatabase