Re: Many aggregates in one query

> 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 - 03:05:01 CDT