SQL brainteaser..FUN!

OK, here is the basic premise. There is a table with 2 columns: name char(20), age integer ... call it table T

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?

I am not a student trying to find someone to do their homework, just someone with enough knowlege of SQL to get themselves in trouble, but not enough to figure this one out.

Please post appropriate responses to the newsgroup and mail a copy to wmarek_at_grci.com

Have fun! Received on Fri Feb 17 1995 - 16:50:01 CET