MySql删除重复数据

来源：互联网发布：js点击事件隐藏编辑：程序博客网时间：2024/05/31 04:03

DELETEFROM    crm_attendanceWHERE    STD_ATTENDANCE_ID IN (        SELECT            id        FROM            (                SELECT                    STD_ATTENDANCE_ID id                FROM                    crm_attendance                WHERE                    (STUDENT_CODE, SCHEDULE_ID) IN (                        SELECT                            STUDENT_CODE,                            SCHEDULE_ID                        FROM                            crm_attendance                        GROUP BY                            STUDENT_CODE,                            SCHEDULE_ID                        HAVING                            count(*) > 1                    )                AND STD_ATTENDANCE_ID NOT IN (                    SELECT                        min(STD_ATTENDANCE_ID)                    FROM                        crm_attendance                    GROUP BY                        STUDENT_CODE,                        SCHEDULE_ID                    HAVING                        count(*) > 1                )            ) ids    );

阅读全文

0 0