Simulate A (mysql)LIMIT On "MS SQLserver"
Join the DZone community and get the full member experience.Join For Free
return lines from 7995 to 8000 (5 lines)
select * from ( select top 5 * from (select top 8000 * from TABLE order by 1 asc) as tbl1 order by 1 desc ) as tbl2 order by 1 asc
Opinions expressed by DZone contributors are their own.