http://www.perlmonks.org?node_id=230872


in reply to Limit results of a DBI query

A neat trick in Oracle (I dont know if MS-SQL supports "rownum" (or inline views)) is 
select column1 
  from (
        select column1, rownum
          from table 1
       )
 where rownum > ? and rownum < ?

[download]

In Section Seekers of Perl Wisdom