You can't specify target table 'BASE_STUDENT' for update in FROM clause

这个的情景就是学生表中有一些学生的数据是重复的，譬如学号重复。我要删除学号重复的这一部分数据。

原本的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
)