[thelist] MySQL query question

Kevin lists at irubin.com
Mon Nov 4 18:14:01 CST 2002


Hello,

I am trying to query a table for all unique ID's that have an average of
"10".

carrier_id    rating
=============
34               10

36                8

30                9

34               10

My result should be carrier_id 34 as it is the only carrier with an average
rating of 10.

Any ideas - I am king of stomped ...

TIA.

-Kevin




More information about the thelist mailing list