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

Question

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

My target output

我的代码

 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

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

Answer 1

您可以尝试以下 - 使用 group by 和 employee_id

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