Re: [SQL-Ledger-users] LARGE INVENTORY

[Matt B. <ma...@li...>]

Seems like this works for MySQL or Postgres.  With Oracle, you can do
things with ROWNUM to similar effect.

Matt


Matt Benjamin President/CTO

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104

tel. 734-761-4689
fax. 734-769-8938
pgr. 734-431-0118

On Wed, 7 Feb 2001 dr...@ss... wrote:


>
> There is a way to pick the next set.  Use the offset keyword.
>
> select * from table where criteria offset START limit LENGTH
>
> --
>   -- Drew Sullivan, <dr...@ss...> -- Toronto, Canada,  +1-416-512-2311
>      Copyleft--all rights reversed
>