FIND nth RECORD USING CURSOR

declare sc cursor static for select * from system1.dbo.sys_params

declare @n int
open sc
set @n=25
while (@n<=29)
begin
fetch absolute @n from sc

set @n=@n +1
end
close sc
deallocate sc