Christoph, this SUMs all values ? On Tue, Sep 28, 2010 at 11:25 AM, Christoph Boget <christoph.bo...@gmail.com > wrote:
> > I've a basic table like and want to SUM the top 5 values. For example if > I > > have > > > > Any suggestions on how to achieve this ? > > > > SELECT SUM( rating ) as total_rating FROM my-table ORDER BY rating DESC > LIMIT 5 > > IIRC, that should work > > thnx, > Christoph > >