[thelist] MySQL query question

rudy r937 at interlog.com
Mon Nov 4 18:37:01 CST 2002


>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

hmmm, completely duplicate rows?  no prob

select distinct carrier_id
  from yourtable
 where rating = 10

rudy




More information about the thelist mailing list