1.仅删除所有葛勤的数据, 时间管理中：打卡记录、考勤明细: delete from hr_attendance where employee_id=(select id from hr_employee where employee_number='EM20200822070'); delete from attendance_period where employee_id=(select id from hr_employee where employee_number='EM20200822070'); 补充报表删除： delete from attendance_count where employee_id=(select id from hr_employee where employee_number='EM20200822070'); 2.删除账号‘曹飞艳’的部分单据 （1）2020/8/25日及之前的曹飞艳的打卡记录 （2）2020/8/25日及之前的曹飞艳的考勤明细 （3）曹飞艳的补卡记录BK202008230111 update hr_attendance set active=False where attendance_date<='2020-08-25' and employee_id=(select id from hr_employee where employee_number='h10347'); update attendance_period set active=False where attendance_date<='2020-08-25' and employee_id=(select id from hr_employee where employee_number='h10347'); update hr_attendance_adjustment set active=False where employee_id=(select id from hr_employee where employee_number='h10347'); 补充报表删除： delete from attendance_count where name<='2020-08-25' and employee_id=(select id from hr_employee where employee_number='h10347');