I want to apply pagination on a table with huge data. All I want to know a better option than using OFFSET in SQL Server. Here is my simple query: Answer You can use Keyset Pagination for this. It’s far more efficient than using Rowset Pagination (paging by row number). In Rowset Pagination, all previous rows must be read, before