比如count()/count()后，想要这个结果为0的不显示，而且保留两位小数该怎么办

select round(count(col1)/count(col2),2) as col from tab_name where count(col1) !=0;

select round(count(col1)/count(col2),2) as col from tab_name where count(col1) !=0 and count(col2) !=0;

1.保留两位小数

select TRUNCATE(1/3,2) "value";

value
0.33

2.为0的数据

select TRUNCATE(0/3,2) "value";

value
0.00
3.在外面包一层将value等于0.00的过滤掉就行了

select * from (
select TRUNCATE(count()/count(),2) "value"
) t where t.`value`!=0.00