Re: Using a MIN with a COUNT

From: Johnny be Good <jboule_at_capitale.qc.ca>
Date: Wed, 24 Nov 1999 08:45:58 -0500
Message-ID: <nZR_3.3371$63.62571@news.globetrotter.net>

You are right this won't work

Stephan Born a écrit dans le message <383BA0F9.A955D27_at_beusen.de>...
> 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
---------------------------------------------------------------

Received on Wed Nov 24 1999 - 07:45:58 CST