Re: Amount of Datasets

Christian Hartmann schrieb:

> 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?

As far as I know you have to use a where-clause, there is no phrase like the one you like to use:

select *
from xyz
where rownum < 11

will return 10 rows

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------