[thelist] MySQL query question
matt g
mrg at members.evolt.org
Mon Nov 4 18:38:00 CST 2002
> From: "Kevin" <lists at irubin.com>
> 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
Hi Kevin,
Is it
SELECT carrier_id
FROM carriers
WHERE rating = 10 ;
or am I missing some element of the question? Substitute whatever your
actual table name is where I've put in "carriers".
Matt G.
More information about the thelist
mailing list