本文介绍了MySQL计算百分比的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个包含 4 个项目的 MySQL 数据库:id(数字)、group_name、employees 和 surveys.
I have a MySQL database with 4 items: id (numerical), group_name, employees, and surveys.
在我的 SELECT 中，我需要根据调查"中的数字计算参加调查的员工"的百分比.
In my SELECT I need to calculate the percentage of 'employees' who, by the number in 'surveys', have taken the survey.
这是我现在的声明:
SELECT
group_name,
employees,
surveys,
COUNT( surveys ) AS test1,
((COUNT( * ) / ( SELECT COUNT( * ) FROM a_test)) * 100 ) AS percentage
FROM
a_test
GROUP BY
employees
这是现在的表格:
INSERT INTO a_test (id, group_name, employees, surveys) VALUES
(1, 'Awesome Group A', '100', '0'),
(2, 'Awesome Group B', '200', '190'),
(3, 'Awesome Group C', '300', '290');
我想通过调查中的数字来计算参加调查的员工的百分比.即如上数据所示，Awesome Group A 为 0%，Awesome Group B 为 95%.
I would love to calculate the percentage of employees who by the number in surveys have taken the survey. i.e. as shown in the data above, the Awesome Group A would be 0% and Awesome Group B would be 95%.
推荐答案
试试这个
SELECT group_name, employees, surveys, COUNT( surveys ) AS test1,
concat(round(( surveys/employees * 100 ),2),'%') AS percentage
FROM a_test
GROUP BY employees
此处演示
这篇关于MySQL计算百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！