Re: Max records

[Jeff Zucker]

Fred T Sanders wrote:

Hi All

Is there a known way of limiting the amount of rows returned by a query.
I'm currently using DBI with CVS files.
The SQL used by DBD::CSV is documented in the SQL::Parser module.  One 
of the features is a LIMIT clause which works similarly to MySQL:

   SELECT $cols FROM $table WHERE foo=$bar ORDER BY foo LIMIT 20

Will return the first 20 rows (ordered by foo).   You can also specify 
an offset starting point and a number of records to return from that 
point onwards.

--
Jeff