用select语句进行某一机构下产品数量合并的问题
jgm kz sl lkrq
0102010580p5002007-7-5 0:00:00
0102010580z1002007-7-5 0:00:00
0102010580f502007-7-5 0:00:00
0103020525p10002007-8-5 0:00:00
0103020525z2502007-8-5 0:00:00
0103020525f1002007-8-5 0:00:00
0103020525p10002007-5-1 0:00:00
0102010580z2502007-5-25 0:00:00
0103040535p5002007-8-20 0:00:00
0103040535z1002007-8-20 0:00:00
0103040535f502007-8-20 0:00:00
0103040535f502007-5-20 0:00:00
我想得出下面这个表不知语句怎么写?
jgm zs
0102010580 900
0103020525 2350
0103040535 700
zs就是将一个 jgm下的所有的kz的sl相加得到.
谢谢
[解决办法]
select jgm,sum(sl) as zs
from table
group by jgm
