I need to select rows

Question

Consider i have thousand rows and i need to fetch 500 to 600 rows in that what should the query to it .Kindly help me out of this.I tried offest fetch next but it doesn't work in sql server .