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

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;
[download]

Comment on Re: Re: Using the DBI to return the first ix/i rows Download Code

Replies are listed 'Best First'.
Re: Re: Re: Using the DBI to return the first ix/i rows by davorg (Chancellor) on Jan 25, 2001 at 16:40 UTC
Sybase doesn't have either of those mechanisms. You need to do it in two steps. `set rowcount 10 select * from table` [download] -- <http://www.dave.org.uk> "Perl makes the fun jobs fun and the boring jobs bearable" - me	[reply] [d/l]