MYSQL常用复合语句（九）

1，统计一个命令执行结果表table1中的成功数和失败数
核心 通过 SUM(CASE when status=’失败’ THEN 1 else 0 END) 统计和是’失败’的数量
SELECT SUM(CASE when status=’失败’ THEN 1 else 0 END) as ‘失败’,
SUM(CASE when status=’成功’ THEN 1 else 0 END) as ‘成功’, FROM (
SELECT * FROM (
SELECT * FROM table1
ORDER BY time DESC
) temp GROUP BY id) temp1