mayur pandit

mayur pandit

  • 1.6k
  • 267
  • 17.2k

sql server 2008 offset keyword not working.

Aug 13 2019 5:29 AM
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. 
 
 
 

Answers (1)