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

**chu2654** · Nov 6th, 2005, 07:15 PM

Hello,
If I have a table have (id, amount) and id can be duplicate. How can I make a recordset having id,amount, amount percentage where amount percentage is group amount/ total amount. How can I make a recordset like this ?

**RhinoBull** · Nov 6th, 2005, 07:24 PM

Grouped by WHAT ???

**chu2654** · Nov 6th, 2005, 09:15 PM

select id, sum(amount) , percentage(groupsum/total) from XXXX group by id

**Hack** · Nov 7th, 2005, 07:27 AM

More of an SQL/database question. Moved to database section.

**vb_dba** · Nov 7th, 2005, 08:29 AM

What type of RDMS are you using (Access, SQL Server, Oracle, etc)?

**si_the_geek** · Nov 7th, 2005, 02:03 PM

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

Code:

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

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

Thread Tools

Display

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

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

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

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

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

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

Posting Permissions