select checkPerson,sum(case when isvalidate='Y' then 1 else 0 end ) as 'pass',sum(case when isvalidate='D' then 1 else 0 end ) as 'reject',count(*) '所有' from t_audit_check_audit group by checkPerson
select case用法
最新推荐文章于 2022-05-29 22:41:41 发布