我的SQL查询用于计算每组最大值的总和 [英] my sql query for calculate sum of max value from each group

问题描述

如何获得由max生成的列的总和


表：

how to get sum of column generated by max

table:

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

获得每组最高费用的总和



答案： 300 + 600 + 500 = 1400

推荐答案

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

它应该正常工作：

It should works properly:

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

尝试：

Try:

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

这篇关于我的SQL查询用于计算每组最大值的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！