一条SQL语句统计不同表的不同数据
SELECT sum(t0) t0,sum(t1) t1 FROM (
SELECT COUNT(*) t0, 0 t1 FROM pdn_aaa WHERE victory_result = '111'
UNION ALL
SELECT 0 t0 ,COUNT(*) t1 FROM pdn_aaa WHERE victory_result = '222'
)t;
一条SQL语句统计不同表的不同数据
SELECT sum(t0) t0,sum(t1) t1 FROM (
SELECT COUNT(*) t0, 0 t1 FROM pdn_aaa WHERE victory_result = '111'
UNION ALL
SELECT 0 t0 ,COUNT(*) t1 FROM pdn_aaa WHERE victory_result = '222'
)t;