这个的情景就是学生表中有一些学生的数据是重复的,譬如学号重复。我要删除学号重复的这一部分数据。
原本的sql:
DELETE
FROM
BASE_STUDENT
WHERE
GRADUATION_YEAR = 2019
AND SERIAL IN (
SELECT
SERIAL
FROM
BASE_STUDENT
GROUP BY
SERIAL
HAVING
count(*) > 1
)
修正后的sql:
DELETE
FROM
BASE_STUDENT
WHERE
GRADUATION_YEAR = 2019
AND SERIAL IN (
SELECT
a.SERIAL
FROM
(
SELECT
SERIAL
FROM
BASE_STUDENT
GROUP BY
SERIAL
HAVING
count(*) > 1
) a
)