http://snippets.dzone.com/posts Fri, 25 Jul 2008 04:58:04 GMT DZone Snippets: mssqlserver code http://snippets.dzone.com/posts/show/4492 return lines from 7995 to 8000 (5 lines) <br /> <br /><code> <br />select * from ( <br />select top 5 * from <br />(select top 8000 * from TABLE order by 1 asc) as tbl1 order by 1 desc <br />) as tbl2 order by 1 asc <br /></code> Wed, 05 Sep 2007 15:02:59 GMT http://snippets.dzone.com/posts/show/4492 manatlan (manatlan)