22,209
社区成员
发帖
与我相关
我的任务
分享
WITH t(员工id,打卡记录) AS (
SELECT '1001','上班打卡正常' UNION ALL
SELECT '1002','下班打卡正常' UNION ALL
SELECT '1003','上班打卡正常' UNION ALL
SELECT '1003','下班打卡正常'
)
SELECT 员工id,CASE SUM(CASE t.打卡记录
WHEN '上班打卡正常' THEN 1
WHEN '下班打卡正常' THEN 2
ELSE 0 END
)
WHEN 1 THEN '未打下班卡员工'
WHEN 2 THEN '未打上班卡员工'
WHEN 3 THEN '出满勤员工' END
FROM t
GROUP BY 员工id