统计中的union all 的使用:
统计 ====>>列转行
1.
select count() as num , “aNum” as type from TableA
union all
select count() as num , “bNum” as type from TableB
union all
select count() as num , “cNum” as type from TableC
union all
select count() as num , “dNum” as type from TableD
- 查成一行:
SELECT
(select COUNT(1) from jcsj_ren WHERE create_date = curdate() and jlzt =1) as addPeopleNum,
(select COUNT(1) from jcsj_hu WHERE create_date = curdate() and jlzt =1) as addHosueHoldNum,
(select COUNT(1) from jcsj_hu_fw WHERE create_date = curdate() and jlzt =1) as addHouseNum,
(select COUNT(1) from jcsj_liuru WHERE createdate = curdate() and jlzt =1) as addFlowInNum,
(select COUNT(1) from jcsj_liuchu WHERE createdate = curdate() and jlzt =1) as addFlowOutNum,
(SELECT count(1) from sqjs_menu WHERE create_time = curdate() and del_flag = 0) as addThreeBuildNum