mysql - 如何使用 Count 一列并由每个 id 分隔

Question

我想计算我的员工分开但合并在一起的出勤率

我的目标输出

我的代码

 SELECT count(employees_id) as numbers FROM attendance WHERE in_time != ' ' AND out_time != ' 'AND employees_id = 1
 SELECT count(employees_id) as numbers FROM attendance WHERE in_time != ' ' AND out_time != ' 'AND employees_id = 260

需要帮助将它们分开谢谢:)

标签： mysql

Answer 1

您可以在下面尝试 -group by与 employee_id 一起使用

SELECT employees_id,count(*) as numbers 
FROM attendance WHERE in_time != ' ' AND out_time != ' '
group by employees_id