Over a million developers have joined DZone.

Simulate A (mysql)LIMIT On "MS SQLserver"

·
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
Topics:

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}