Re: select limit rows

If you mean by this the first and last record, you can try

SELECT * FROM table_x
WHERE rowid = (SELECT min(rowid) from table_x)   OR rowid = (SELECT max(rowid) from table_x);

Greetings,
Wim Valgaeren

frank chien <chien2_at_ms5.hinet.net> wrote in message news:941782531.996977_at_m5.pagic.net...
> Dear all,
>
> How can I select limit row from the Oracle database?
>
>
Received on Fri Nov 05 1999 - 06:36:31 CST