注册 登录
编程论坛 SQL Server论坛

如何求出入库与出库的总数之差啊?

yuer1231 发布于 2007-05-28 20:14, 725 次点击
create table item
(
no char(20) not null,
flag char(1) not null,
num int not null
)
--flag 为1时是入库,为2时是出库
insert into item values('01','1',200);
insert into item values('01','2',100);
insert into item values('02','1',100);
insert into item values('02','2',30);
如何求出入库与出库的总数之差啊?
2 回复
#2
yuer12312007-05-28 21:07

知道了,呵呵

#3
lzalibabalr2007-08-01 23:19
SELECT (SELECT SUM(num)
FROM item
WHERE flag='1')
-
(SELECT SUM(num)
FROM item
WHERE flag='2')
1