Re: SQL brainteaser..FUN!

Walter Marek (wmarek_at_grci.com) wrote:
> Here is some sample data :
> Tom,24
> Dick,40
> Harry,41
> Sally,24
> Mary,35
> Suzy,29
> We want to find out the AGE that occurs most frequently?
> What SQL query would return an answer of 24, not 2?
> a copy to wmarek_at_grci.com

I think this should work:
select age
from table
group by age
having count(*) = (select max(count (*))

                      from   table
                   group by  age )

--
**************************************************************
*                          Saad Ahmad                        *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************