DELETE Att_StaffHandSign
WHERE RecID IN( SELECT MAX(RecID) FROM (
SELECT A.RecID,
A.StaffNumber,
A.HandSignDate,
A.HandSignTime
FROM Att_StaffHandSign A
LEFT JOIN Att_StaffHandSign B ON A.StaffNumber = B.StaffNumber AND A.HandSignDate=B.HandSignDate AND A.HandSignTime=B.HandSignTime AND A.RecID<>B.RecID
WHERE A.HandSignDate=B.HandSignDate AND A.HandSignTime=B.HandSignTime AND A.RecID<>B.RecID
) AS A GROUP BY StaffNumber,HandSignDate,HandSignTime );