sql sum with limit : I have a mysql  table with that is called transactions and have the following fields
user varchar, amount float
I want to make a group by like this
SELECT user, SUM(amount) as S FROM (SELECT * FROM transactions ORDER BY amount DESC ) t GROUP BY user, s
but i want to limit the sum only on the top 10 ammounts.
Is it possible to do that with plain sql?