Re: Many aggregates in one query
From: Matti Teppo <matti.teppo_at_nospam.deio.net>
Date: Fri, 17 Aug 2001 10:05:01 +0200
Message-ID: <3B7CD02D.2F282C07_at_nospam.deio.net>
Date: Fri, 17 Aug 2001 10:05:01 +0200
Message-ID: <3B7CD02D.2F282C07_at_nospam.deio.net>
> If you're using mySQL you can use the LIMIT clause which is specific to this
> DBMS and do the following :
> SELECT wsid, count(wsid) AS rowcnt
> FROM test
> GROUP BY wsid
> ORDER BY rowcnt ASC
> LIMIT 1;
>
> You just get the first result.
Thank you, but I use Sybase so LIST is not available.
> > I have a problem, for which I'm sure there is a simple answer but I
> > can't see it.
So this is not as simple as I thought... Received on Fri Aug 17 2001 - 10:05:01 CEST