SELECT query with paging facility with MS SQL server.

 SELECT * 

FROM( 

SELECT * , ROW_NUMBER() OVER(ORDER BY _uri) AS RowNum FROM db_accessadmin.SURVEY_MASTER_DATA_FILE_CORE 

) AS MyDerivedTable 

WHERE MyDerivedTable.RowNum BETWEEN 0 AND 50.

Note:- where uri is the unique key column. and we can change start and end (between 0 and 50)