Re: AVG question

Hello. On Wed 2002-10-30 at 16:45:00 -0800, [EMAIL PROTECTED] wrote: > Hello, > > I am trying to query a table for all unique ID's that have an average of > "10". > > carrier_idrating > = > 34 10 > 368 > 309 > 34 10 > >

AVG question

Hello, I am trying to query a table for all unique ID's that have an average of "10". carrier_idrating = 34 10 368 309 34 10 My result should be carrier_id 34 as it is the only carrier with an average rating of 10. A