select 司磅员,count(*) as 产量 from a1 where 毛重时间 between '2010-3-1' and '2010-4-1' group by 司磅员 select 皮重司磅员 as 司磅员,count(*) as 产量 from a1 where 皮重时间 between '2010-3-1' and '2010-4-1'select 司磅员,count(*) as 产量 from PZ where 时间 between '2010-3-1' and '2010-4-1' group by 司磅员怎样把这三个SELECT语句统计出来的产量按司磅员名字分别相加?
解决方案 »
- 想要两台SQL2005服务器间某个表的数据每日自动同步,哪种方法比较好?
- 如何做顺次执行多条SQL语句
- 一个BCP为后缀的文件如果导入数据库
- 如何获取一个表的,字段,类型,长度,是否主键,是否为空,注释 等信息
- 在繁体系统下部署了一个简体asp系统,显示数据库数据时变成乱码,如何解决?还是时间也有问题
- 如何去除不想显示的字段(我的字段特多,我只想不显示几个),如何设置?
- Sql Server 2005 语句转 2000
- 请问 如何把已有的SQL SERVSER 2000 的数据库导入其中
- 高手请进
- 查询结果显示的问题,在线等待给分;)
- sql语句优化,表中有10万条记录
- 执行SQL2000DTS包调度时报错,请高手指点!
from tb1,tb2,tb3
where tb1.司磅员=tb2.司磅员 and tb2.司磅员=tb3.司磅员
sum(产量)产量
from
select 司磅员,count(*) as 产量 from a1 where 毛重时间 between '2010-3-1' and '2010-4-1' group by 司磅员
union all
select 皮重司磅员 as 司磅员,count(*) as 产量 from a1 where 皮重时间 between '2010-3-1' and '2010-4-1'
union all
select 司磅员,count(*) as 产量 from PZ where 时间 between '2010-3-1' and '2010-4-1' group by 司磅员
)t
group by 司磅员
select 司磅员,
sum(产量)产量
from
(
select 司磅员,count(*) as 产量 from a1 where 毛重时间 between '2010-3-1' and '2010-4-1' group by 司磅员
union all
select 皮重司磅员 as 司磅员,count(*) as 产量 from a1 where 皮重时间 between '2010-3-1' and '2010-4-1'
union all
select 司磅员,count(*) as 产量 from PZ where 时间 between '2010-3-1' and '2010-4-1' group by 司磅员
)t
group by 司磅员
a.产量+b.产量+c.产量
from
(select 司磅员,count(*) as 产量 from a1 where 毛重时间 between '2010-3-1' and '2010-4-1' group by 司磅员 )a,
(select 皮重司磅员 as 司磅员,count(*) as 产量 from a1 where 皮重时间 between '2010-3-1' and '2010-4-1')b,
(select 司磅员,count(*) as 产量 from PZ where 时间 between '2010-3-1' and '2010-4-1' group by 司磅员)c
where
a.司磅员=b.司磅员 and b.司磅员=c.司磅员
select t1.产量+t2.产量+t3.产量 from
(
select 司磅员,count(*) as 产量 from a1 where 毛重时间 between '2010-3-1' and '2010-4-1' group by 司磅员
) t1
join
(
select 皮重司磅员 as 司磅员,count(*) as 产量 from a1 where 皮重时间 between '2010-3-1' and '2010-4-1'
) t2
on t1.司磅员=t2.司磅员
join
(
select 司磅员,count(*) as 产量 from PZ where 时间 between '2010-3-1' and '2010-4-1' group by 司磅员
) t3
on t2.司磅员=t3.司磅员