Re: SQL brainteaser..FUN!

In article <D4oCon.HGJ_at_sybase.com> robert_at_sybase.com (Robert Garvey) writes:
>
>You should be able to eliminate the second
>select using this form:
>
> select age, count(*)
> from t
> group by age
> having count(*) = max(count(*))
>
>- Robert
> robert.garvey_at_sybase.com Sybase, Inc 6475 Christie Ave
> Emeryville, CA USA 94608-1010
>Opinions may be attributed to poster, not necessarily related to Sybase.

This is a nice way to do it /*I'm Impressed! :-) */, but unfortunately /* :-( */ it doesn't work in Oracle. "group function nested too deeply" or something like that.

This is the second thread I've followed in the last month that Sybase has out-done Oracle.

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!" Received on Fri Mar 03 1995 - 14:32:38 CET