Re: select the first ten row

Alex wrote:
>
> Hi,
> How can I select the first ten row of a table in a efficiency way?

Hi,
You can use the ROWNUM pseudocolumn to limit the number of rows returned by a query, as in this example:

SELECT * FROM table

        WHERE ROWNUM <= 10; Received on Mon Feb 10 1997 - 00:00:00 CST