Paging in C# not working properly

See more:

SQL-Server

ADO.NET

WCF

There is a GRID on UI which displays page by page information as ">>" button is clicked. This button fetches data from database using the following query:

with y 
as 
(
    select 
      version, 
      Id ,
      row_number() over (order by Id,version) r 
    from 
      X
)
select 
  Id,
  version 
from 
   y 
where 
   r>20 and r<30

X is a contract table with ID of Contract and Version together as primary key. A lot of terms of the contract are there which will be the columns. The version is to maintain a trail of changes made to any contract.

If currently loaded rows in the grid is between row_number() 1 to 10 .. and before the user clicks the ">>" button if newer version comes in the database for Ids already displayed on UI, the row_number() count will not work .. also I need to display all records via paging in GRID