统计中的union all 的使用

统计中的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

2. 查成一行:
   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