Excellent, thanks.
Fred
s
On June 14, 2003 4:05 pm, Jeff Zucker wrote:
> 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.
