select top 1 sum(blah) from group by blah orider by sum(blah) desc
少了个blah select top 1 sum(blah) from blah group by blah orider by sum(blah) desc
select cardID, sum(case when cardID=cardID then tradeMoney*(case when tradeType='存入' then 1 else -1 end ) else 0 end ) as sum tradeMoney from tradeInfo group by cardID
select top 1 sum(blah) from blah group by blah orider by sum(blah) desc
也可以把得到的结果写入CTE中 然后再max或者top 1随便你
select top 1 sum(blah)'Total' from blah group by blah orider by Total desc
select top 1 sum(blah) from blah group by blah orider by sum(blah) desc
select cardID,
sum(case when cardID=cardID then tradeMoney*(case when tradeType='存入' then 1 else -1 end ) else 0 end ) as sum tradeMoney
from tradeInfo
group by cardID