Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

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
to sql mssqlserver by manatlan on Sep 05, 2007
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS