用union all进行统计(好方法)
来源:互联网 发布:mac电脑文件管理 编辑:程序博客网 时间:2024/06/07 00:47
--当前库存
declare @cur table(id int,num int)
insert into @cur
select 1,100 union all select 2,200 union all select 3,300
--入库数
declare @in table(id int,num int)
insert into @in
select 1,300 union all select 3,400 union all select 4,700
--出库数
declare @out table(id int,num int)
insert into @out
select 1,200 union all select 2,500 union select 3,100
select * from
(
select id,curnum=num,innum = 0,outnum = 0 from @cur
union all
select id,curnum=0,innum = num,outnum=0 from @in
union all
select id,curnum = 0,innum = 0,outnum = num from @out ) a
---------------------
select id,innum = sum(innum),outnum = sum(outnum),curnum=sum(curnum)
from (
select id,curnum=num,innum = 0,outnum = 0 from @cur
union all
select id,curnum=0,innum = num,outnum=0 from @in
union all
select id,curnum = 0,innum = 0,outnum = num from @out ) a group by id
- 用union all进行统计(好方法)
- SQL 统计的用法(Union All)
- mysql union all的一种优化方法
- 多表或单表数量统计 使用union all
- union all
- Union all
- union all
- union all
- union all
- union all
- union all
- union,union all 等
- union all 和union
- UNION,UNION ALL,MINUS
- union union all
- UNION and UNION All
- union 和 union all
- UNION与UNION ALL
- Linux Socket 编程原理详解
- 汉澳现代战争军事指挥作战系统以及预测利比亚战争
- No Dialect mapping for JDBC type
- CSS入门经典-知识点摘录
- extern "C"的惯用法
- 用union all进行统计(好方法)
- 第三阶段:Java初级 ------- 高新技术
- const使用详解
- 梦想与现实
- static用法1
- 树编码
- static用法2
- WPF版本的自动更新程序
- C程序的算法测试总结