bitsCN.com
一條sql語句實作統計查詢
如圖：程式員在進行如下的統計時，現在提供兩種實作方案：
方案一：運用 SEKECT CASE WHEN
EXPLAIN SELECT count(*) AS '總數', count( CASE oup.status WHEN '1' THEN oup.id END ) AS '未綁定', count( CASE oup.status WHEN '2' THEN oup.id END ) AS '已綁定', count( CASE oup.status WHEN '3' THEN oup.id END )AS '當機中' FROM lab_org_uc_passport oup
顯示結果：(按行顯示)
方案二：
SELECT count(*) AS '總數' FROM lab_org_uc_passport oup UNION ALL SELECT count(*) AS '未綁定' FROM lab_org_uc_passport oup WHERE oup.status = '1' UNION ALL SELECT count(*) AS '未綁定' FROM lab_org_uc_passport oup WHERE oup.status = '2' UNION ALL SELECT count(*) AS '未綁定' FROM lab_org_uc_passport oup WHERE oup.status = '3'
顯示結果(按列顯示)
34
3
10
21
bitsCN.com
本文原創釋出php中文網，轉載請注明出處，感謝您的尊重！