Is it possible to do a key set pagination for nvarchar(max) column in sql server
I understand that its possible for int, dates as we can check < value or > value
Suppose I have a table
| Someid | Name |
|---|---|
| 1 | Abc |
| 2 | Cde |
Currently its written something like this
SELECT * FROM table
WHERE 'somelogic'
Order by Name Asc Offset 1 fetch 1
The problem is its currently ordered by Name because thats the requirement In page number 100th its taking a lot of time to fetch the result
Edit: Currently there is no condition present on filtering the result based on Name (where Name='somename' -- this is not present) only its being orderd by Name Asc. This is offset pagination if I am not wrong. I want to know if I can do a Keyset pagination for that.