Re: Using a MIN with a COUNT

From: Stephan Born <stephan.born_at_beusen.de>
Date: Wed, 24 Nov 1999 14:20:33 +0100
Message-ID: <383BE621.1AF6133C@beusen.de>

> How about this statement?
>
> SELECT MIN(CNT), nbDesks
> FROM
> (SELECT COUNT(nbDesks) CNT, nbDesks
> FROM rooms
> GROUP BY (nbDesks));

This will not run because of

ORA-00937: not a single-group group function

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:20:33 CST