SUM Top 10 records

[Tompkins Neil]

Hi

I've a basic table like and want to SUM the top 5 values.  For example if I
have

id, rating
0, 10
1, 25
2, 5
3, 10
4, 50
5, 1
6, 15
7, 20
8, 9

I want my query to sum the values

4,50
1,25
7,20
6.15
0,10

Suming a value of 120

Any suggestions on how to achieve this ?

Cheers
Neil