我有这样一张表:
------------------
sl no | Error type
------------------
1 | err1
------------------
2 | err2
------------------
3 | err1
------------------
4 | err2
------------------
5 | err2
------------------
6 | err3
------------------
Result I want:
---------------------------
Error type | Count | %
---------------------------
err1 | 2 | 33.33
---------------------------
err2 | 3 | 50
---------------------------
err3 | 1 | 16.66
---------------------------
我正在使用以下查询来获取上述结果:
select
error as Error,
count(*) as Count,
100* count(*)/(select count(*) from logs) as Percentage
from logs
group by error;
它是否针对任务进行了优化?如果没有,我有哪些其他有效的方法可以获取这些信息?
select count(*) from logs
子查询吗?还是你有其他的疑虑? - undefined