一條sql語句實現統計查詢

程式員在進行如下的統計時，現在提供兩種實現方案：


方案一：運用 SEKECT CASE WHEN　

EXPLAINSELECTcount(*) AS '總數',count(CASE oup.statusWHEN '1' THENoup.idEND) AS '未綁定',count(CASE oup.statusWHEN '2' THENoup.idEND) AS '已綁定',count(CASE oup.statusWHEN '3' THENoup.idEND)AS  '凍結中'FROMlab_org_uc_passport oup

顯示結果：(按行顯示)



方案二：

SELECT count(*) AS '總數' FROM lab_org_uc_passport oup UNION ALLSELECT count(*) AS '未綁定' FROM lab_org_uc_passport oup WHERE oup.status = '1'UNION ALLSELECT count(*) AS '未綁定' FROM lab_org_uc_passport oup WHERE oup.status = '2'UNION ALLSELECT count(*) AS '未綁定' FROM lab_org_uc_passport oup WHERE oup.status = '3'

顯示結果(按列顯示)

3431021