如图示：请问一下，sql 语句怎么拼写？
如图示：请问一下，sql 语句怎么拼写？ 谢谢！
[解决办法]
try this,
select a.MNAME,
max(a.MSTANDARD) 'MSTANDARD',
max(a.MUNIT) 'MUNIT',
max(a.COUNTONE) 'COUNTONE',
max(a.FEEONE) 'FEEONE',
sum(a.COUNTTWO) 'COUNTTWO',
sum(a.FEETWO) 'FEETWO',
max(a.COUNTTHREE) 'COUNTTHREE',
max(a.FEETHREE) 'FEETHREE',
max(a.COUNTONE)+sum(a.COUNTTWO)-max(a.COUNTTHREE) 'COUNTFOUR',
max(a.FEEONE)+sum(a.FEETWO)-max(a.FEETHREE) 'FEEFOUR'
from [表名] a
group by a.MNAME
select
a.MNAME,
max(a.MSTANDARD) "MSTANDARD",
max(a.MUNIT) "MUNIT",
max(a.COUNTONE) "COUNTONE",
max(a.FEEONE) "FEEONE",
SUM(a.COUNTTWO) "COUNTTWO",
SUM(a.FEETWO) "FEETWO",
max(a.COUNTTHREE) "COUNTTHREE",
max(a.FEETHREE) "FEETHREE",
SUM(a.COUNTONE + a.COUNTTWO - a.COUNTTHREE) "COUNTFOUR",
SUM(a.FEEONE + a.FEETWO - a.FEETHREE) "FEEFOUR"
from [表名] a
group by a.MNAME
