How can I make a group amount/ total amount recordset ?

[si_the_geek]

Potentially something like this, if the DBMS supports subqueries in the Select clause:

select id, sum(amount) , (sum(amount) /  (select sum(amount) from XXXX))*100 from XXXX group by id