Gridview Paging Query With Row_Number()

 

eg.

 

get records between 201 and 300

select * from (

SELECT row_number() over (order by column1, column2 as rowindex) as rowindex , * from BOM_Lists_Transfer_Test )as tablewithrowindex where  (rowindex between 201 and 300 ) and …..