[thelist] MySQL query question
Anthony Baratta
Anthony at Baratta.com
Mon Nov 4 19:02:00 CST 2002
At 04:20 PM 11/4/2002, Kevin wrote:
>Hello,
>
>I am trying to query a table for all unique ID's that have an average of
>"10".
I think you are looking for something like this:
Select carrier_id, Avg(rating)
from Table_Name
Group By carrier_id
Having Avg(rating) = 10
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list