1
select ITEM_NAME,DS from REPORT_YJ where CHARGE_DATE='30-1月-2023'
2
select ITEM_NAME,RS from REPORT_YJ where CHARGE_DATE='30-1月-2023'
3
select ITEM_NAME,sum(DS)
from REPORT_YJ
where CHARGE_DATE between '20-9月-2022' and '30-1月-2023'
group by ITEM_NAME
4
select ITEM_NAME,sum(RS)
from REPORT_YJ
where CHARGE_DATE between '20-9月-2022' and '30-1月-2023'
group by ITEM_NAME
怎么能把四条查询语句合成一句?
能出现这样的查询结果
楼上说的还是复杂了,最简单的是用分号(;)
select ITEM_NAME,DS from REPORT_YJ where CHARGE_DATE='30-1月-2023';
select ITEM_NAME,RS from REPORT_YJ where CHARGE_DATE='30-1月-2023';
select ITEM_NAME,sum(DS)
from REPORT_YJ
where CHARGE_DATE between '20-9月-2022' and '30-1月-2023'
group by ITEM_NAME;
select ITEM_NAME,sum(RS)
from REPORT_YJ
where CHARGE_DATE between '20-9月-2022' and '30-1月-2023'
group by ITEM_NAME;
1、最简单的方式:UNION ALL