sql server 2008 offset keyword not working.

Question

Dear All,

Below query is not working in sql server 2008. OFFSET keyword not available in this sql version. I want to get next 10 record every time on button click.

 

select * from users order by userid asc OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY

 

kindly suggest if there is another option for this senario.

 

Thank you in advance.