如何合并对一个表的两个查询结果成一个表

2005-04-20 08:03:32 255 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

如何将多个Excel 表合并成一个怎么把数据格式一样的表格汇总到一起？准备数据，业务报告汇总.xlsx是新建的一个空白的表格，sum文件夹里放的是需要汇总的数据格式是一模一样的，如下图：分两种方法：一 excel图形化操作 1 业务报告汇总文件 2 点击数据--点击新建查询--点击从文件--选择从文件夹 3 点击浏览--选择需要合并的所有表格的文件夹--点击确定 4 选择加载合并数据或者... 阅读详情

有表结构如下：
a(a1,a2,a3,a4)
a1可以重复为字符串型,值为'1'..'9'，a2,a3为整数型
现做如下查询，1。select sum(a2)+sum(a3) from a where a1<'6' group by a1
2.select sum(a2)-sum(a3) from a where a1>'6' group by a1

谢谢！

...全文

STM32单片机：驱动ADS1115四个通道全开程序本文介绍了德州仪器(TI)的ADS1115高精度16位模数转换器(ADC)及其应用实现。该芯片具有16位分辨率、可编程增益放大器(PGA)和低功耗特性，支持±0.256V至±6.144V量程。文章提供了完整的C语言驱动代码，包括初始化、配置寄存器读写、单次/连续转换模式设置、电压值读取等功能实现。代码通过I2C接口与ADS1115通信，支持多通道选择和不同PGA设置，可实现高精度模拟信号采集。该方案适用于需要精密测量的嵌入式系统，如传感器数据采集等应用场景。阅读详情

churchatp1

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

631799 2005-04-21

打赏
举报

或者：

select 1,sum(cast(a2 as numeric))+sum(cast(a3 as numeric)),a1 from a where a1<'6' group by a1
union all
select 2,sum(cast(a2 as numeric))-sum(cast(a3 as numeric)),a1 from a where a1>'6' group by a1
order by 1

631799 2005-04-21

打赏
举报

select * from(
select top 100 percent sum(cast(a2 as numeric))+sum(cast(a3 as numeric)) from a where a1<'6' group by a1 order by 字段1) a
union all
select * from(
select top 100 percent sum(cast(a2 as numeric))-sum(cast(a3 as numeric)) from a where a1>'6' group by a1 order by 字段2) b

churchatp1 2005-04-21

打赏
举报

不好意思，是我自己弄错了，日期赋值错误，所以没有结果

paoluo 2005-04-20

打赏
举报

晕，怎么会不行？？不行指什么？？得不到值还是查询不出来？？

churchatp1 2005-04-20

打赏
举报

我刚开始就是这么做的，好象不行

paoluo 2005-04-20

打赏
举报

那为你那一列取一个别名，如下面的SUMa。

select (sum(cast(a2 as numeric))+sum(cast(a3 as numeric))) As SUMa,a1 from a where a1<'6' group by a1
union all
select (sum(cast(a2 as numeric))-sum(cast(a3 as numeric))) As SUMa,a1 from a where a1>'6' group by a1
order by a1

现在应该知道怎么取了吧。

churchatp1 2005-04-20

打赏
举报

我要取这个合成表的sum(cast(a2 as numeric))-sum(cast(a3 as numeric))字段，改怎么办？

paoluo 2005-04-20

打赏
举报

取它的字段？？哪个？？

churchatp1 2005-04-20

打赏
举报

这样的话我要去取他的字段怎么取啊？谢谢

paoluo 2005-04-20

打赏
举报

试试

select sum(cast(a2 as numeric))+sum(cast(a3 as numeric)),a1 from a where a1<'6' group by a1
union all
select sum(cast(a2 as numeric))-sum(cast(a3 as numeric)),a1 from a where a1>'6' group by a1
order by a1

churchatp1 2005-04-20

打赏
举报

错了，我是这样写的：
我也是用union的，select * from （select sum(cast(a2 as numeric))+sum(cast(a3 as numeric)),a1 from a where a1<'6' group by a1
union all
select sum(cast(a2 as numeric))-sum(cast(a3 as numeric)),a1 from a where a1>'6' group by a1
）as m order by a1
提示出错
oeder by不可少该怎么写，谢谢

churchatp1 2005-04-20

打赏
举报

我也是用union的，select * from （select sum(cast(a2 as numeric))+sum(cast(a3 as numeric)),a4 from a where a1<'6' group by a1
union all
select sum(cast(a2 as numeric))-sum(cast(a3 as numeric)),a4 from a where a1>'6' group by a1
）as m order by a4
提示出错

churchatp1 2005-04-20

打赏
举报

to 新新人类：
不行啊，连接起来就不能用order by了，我还要用order by

chiwei 2005-04-20

打赏
举报

select
A=(select sum(a2)+sum(a3) from a where a1<'6' group by a1),
B=(select sum(a2)-sum(a3) from a where a1>'6' group by a1)

Andy__Huang 2005-04-20

打赏
举报

select sum(cast(a2 as numeric))+sum(cast(a3 as numeric)) from a where a1<'6' group by a1
union all
select sum(cast(a2 as numeric))-sum(cast(a3 as numeric)) from a where a1>'6' group by a1

如何合并对一个表的两个查询结果成一个表

相关推荐