怎么能把四条查询语句合成一句?

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
怎么能把四条查询语句合成一句?
能出现这样的查询结果

img

楼上说的还是复杂了,最简单的是用分号(;)


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