Question

求教oracle 数据库 字段求和语句

oracle 数据库中某数据库weight表的Netweight 字段为货物的净重数，我想求所有记录netweight合计数，请问语句怎么写？

Answer 1

select t.bm,
(select count(*) from a where a.zl1=1 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from a where a.zl1=2 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from b where b.bm=t.bm group by b.bm) as qt
from a tclwyzx希望有所提示，有空到51cto,365testing进一步交流!

Answer 2

select t.bm,
(select count(*) from a where a.zl1=1 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from a where a.zl1=2 and a.bm=t.bm group by a.bm) as zl1,
(select count(*) from b where b.bm=t.bm group by b.bm) as qt
from a thello希望对你有帮助。更多到

Answer 3

select sum(netweight) “净重合计” from weight;

Answer 4

sun(字段名称)

Answer 5

select sum(netweight) from weight