[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