Show data

thank, but i still not understand about this code yet.
please show me with simple data?
coz i need to use it with .net language.

 try like this, or wait for more replies..

 if object_id('tempdb..#t1') is not null
 DROP TABLE #t1;

 with cte as (
    select 10 id
    union
    select 20
    union
    select 30
    union
    select 40
    union
    select 50
    union
    select 60
    union
    select 70
    union
    select 80
    union
    select 90
    union
    select 100
 )
 select ROW_NUMBER() over (order by id) as rn, id into #t1 from cte

 --select * from #t1 where rn between 1 and 5 (for your case 1 and 20)
 select * from #t1 where rn between 6 and 10 (for your case 21 and 40)

 
 You need to store the next between value and later send to db and fetch the record.
 The values must be dynamic, do not hard code..