Select sum(KSM03014) as ksm03014 from ksm03,ksm01 where 连接条件 and KSM03018 ='V' group by ksm01010 ; 按部门进行分组求和,只有一个值,是不是你只有一个部门呢?
Select ksm01010,sum(KSM03014) as ksm03014 from ksm03,ksm01 where ksm03007=ksm01007 and KSM03018 ='V' group by ksm01010 ; 是这个意思吧! 在select语句中可以指定分组字段的
大概明白你的意思,其实你写的没错,如果你要合计很多项的话,就得这样写: Select ksm01010,sum(KSM03014),sum(Item1),sum(Item2),... as ksm03014 from ksm03,ksm01 where ksm03007=ksm01007 and KSM03018 ='V' group by ksm01010 ;但要注意不要这样: SELECT ColumnA, ColumnB, SUM(ColumnC) AS SumC FROM TableX GROUP BY ColumnA 这样写是错的!
group by ksm01010 ;
按部门进行分组求和,只有一个值,是不是你只有一个部门呢?
group by ksm01010 ;
是这个意思吧!
在select语句中可以指定分组字段的
Select ksm01010,sum(KSM03014),sum(Item1),sum(Item2),... as ksm03014 from ksm03,ksm01 where ksm03007=ksm01007 and KSM03018 ='V'
group by ksm01010 ;但要注意不要这样:
SELECT ColumnA,
ColumnB,
SUM(ColumnC) AS SumC
FROM TableX
GROUP BY ColumnA
这样写是错的!