[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