Re: Re: Using the DBI to return the first ix/i rows

[eg]

In case you're using Oracle: you don't have a LIMIT SQL command (go figure), so you need to use ROWNUM instead:

SELECT * FROM table WHERE ROWNUM < 10;

[davorg]

Sybase doesn't have either of those mechanisms. You need to do it in two steps.

set rowcount 10
select * from table

--
<http://www.dave.org.uk>

"Perl makes the fun jobs fun
and the boring jobs bearable" - me