Re: Using a MIN with a COUNT

> Do you mean something like
> SELECT COUNT(r1.nbDesks), nbDesks
>
> FROM rooms r1
> where rownum=1
> GROUP BY (nbDesks)
> ORDER BY 1 ASC;
>

As far as I know this will not necessarily return what you want since rownum is created BEFORE the ORDER BY
will take affect....

Tell me if I am wrong

Regards, Stephan

--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------