>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