Select top 500 rows, but after 501 to 1000?
798064Sep 15 2010 — edited Sep 15 2010Hi!
Is there a way to 'select top 500 * from my_table' and after using the same idea, select top 500, but now I'd like to get 501 to 1000???
It's a little complicated to explain...
Something like that:
'select top 500 * from my_table'
rows 1-500
'select top 500 * from my_table'
rows 501-1000
Thanks!
Edited by: user1050540 on 15/09/2010 11:16