Re: how to limit the output?

Try:

  SELECT * FROM table WHERE ROWNUM <= 3;

HTH,
Brian

Martin Meister wrote:
>
> Hi anybody,
>
> is there in oracle a mechnism to limit the output to 3 colums. In MySQL
> works:
>
> select * from table limit 3
>
> I didn't found anything similar in the oracle documentation.
>
> any suggestions??
>
> CU
>
> martin
Received on Tue Oct 26 1999 - 07:46:53 CDT