my sql query for calculate sum of max value from each group

Question

0.00/5 (No votes)

See more:

how to get sum of column generated by max

table:

group             fees
1               200
1               300
2               200
2               400
2               600
3               500

get sum of max fees from each group

Answer : 300+600+500=1400

Posted 11-Feb-13 1:54am

tushar Vayangankar

Updated 11-Feb-13 2:02am

Maciej Los

v2

Add a Solution

3 solutions

Solution 3

Try:

SQL

SELECT SUM(maximum) FROM 
   (SELECT MAX(fees) as maximum FROM myTable GROUP BY [group]) a

Posted 11-Feb-13 2:09am

OriginalGriff

Comments

tushar Vayangankar 11-Feb-13 8:31am

Thanx

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Irbaz Haider Hashmi · Accepted Answer · 2013-02-11T02:00:00

Solution 1

SQL

select group,sum(Fees) as TotalFees 
from
(
Select group,max(fees) as Fees
from Table
group by group
)A

Posted 11-Feb-13 2:00am

Irbaz Haider Hashmi

Comments

tushar Vayangankar 11-Feb-13 8:31am

Thanx

Maciej Los · Accepted Answer · 2013-02-11T02:06:00

Solution 2

It should works properly:

SQL

SELECT SUM([fees]) AS MaxOfFees
FROM (
    SELECT [group], MAX([fees]) AS [fees]
    FROM YourTable
    GROUP BY [group])

Posted 11-Feb-13 2:06am

Maciej Los

Comments

tushar Vayangankar 11-Feb-13 8:31am

Thanx

Maciej Los 11-Feb-13 8:39am

You're welcome ;)
If my answer was helpful, please rate it.

my sql query for calculate sum of max value from each group

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

my sql query for calculate sum of max value from each group

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us