摘要:
SELECT UserId, SUM(Case ComeLate WHEN 'True' THEN 1 ELSE 0 END) AS 迟到次数,SUM(Case OverTimeStart WHEN '2000-01-01 00:00:00.000' THEN 0 ELSE 1 END)AS 加班次数FROM AttendanceRecordGROUP BY UserIdSELECT AttendanceRecord.UserId, Users.TrueName,Users.Position,Users.BasicWage, SUM(Case Attendanc 阅读全文