Re: SQL Question re group averaging

SELECT ...
FROM...
WHERE...
GROUP BY product_id...

"Jonathan Driller" <jdriller_at_orchid.org> wrote in message news:a8cff9fb.0106120924.3f6b6714_at_posting.google.com...
> I finally realized that I need to set an alias to use aggregate
> functions but still can't get what I need:
> I have a table of rankings for lots of products. I want to be able to
> say 'this
> product had 20 people rank it and the average rank is 7".
> If I say select sum(srating) then I sum every product together so I
> figure I need some where clause, but I can't figure out how to do
> this.
>
> I am using Cold Fusion so I can pass in a dynamic value If I wanted to
> get this for one item - but I want to output a list of ALL items and
> their values separately...
> 'where prodid = #prodid#'
>
> Any help much appreciated.
Received on Sun Jul 22 2001 - 01:30:50 CEST