sql语句查询出同一个字段中相同数据占的百分比

[zhcocoaoao]

id name state
1 a 1
2 b 1
3 c 1
4 d 1
5 e 1
6 f 2
7 g 0


数据表如上 state中1代表通过 2代表不通过 0代表未审核
想查询出通过率 跟未通过率

[ACMAIN_CHM]

select sum(if(state=1,1,0))/count(*) as `通过率`, sum(if(state=1,2,0))/count(*) as `未通过率` from 数据表如上

[qiuzhuo110]

引用 1 楼 ACMAIN_CHM 的回复:

select sum(if(state=1,1,0))/count(*) as `通过率`, sum(if(state=1,2,0))/count(*) as `未通过率` from 数据表如上

正解

[蜗牛慢慢向上爬]

ACMAIN_CHM 好牛啊

[kimsung]

引用 1 楼 ACMAIN_CHM 的回复:

select sum(if(state=1,1,0))/count(*) as `通过率`, sum(if(state=1,2,0))/count(*) as `未通过率` from 数据表如上

不是 select sum(if(state=1,1,0))/count(*) as `通过率`, sum(if(state=2,1,0))/count(*) as `未通过率` from 数据表如上 吗？