SELECT eligrate,count(*)case when eligrate = 100 then ’100%’when eligrate is null then ‘数据缺失’when eligrate >= 1 and eligrate <= 99 then‘未达到100%’else‘全部数据’end 合格率标志FROM 表名group by case when eligrate = 100 then ’100%’when eligrate is null then ‘数据缺失’when eligrate >= 1 and eligrate <= 99 then‘未达到100%’else‘全部数据’end 合格率标志 |