Re: Amount of Datasets

WHERE ROWNUM < 3;

has some problems, especially when sorting :) but my be what you are asking.

Randy

Christian Hartmann wrote:
>
> Hi there,
>
> how am I able to restrict the amount of datasets given back with a
> SQL-Statement like "SELECT * FROM XYZ".
>
> I don't think about a where-phrase, but something like "SELECT TOP 3 FROM
> XYZ" as I can use it with MS-SQL-Server.
>
> Is there a way?
>
> Ciao,
>
> Christian Hartmann
Received on Wed Sep 22 1999 - 15:38:18 CDT