MySQL 删除重复项

Mysql 删除重复记录，保留id最大的记录，参考SQL如下

DELETE tbl_exam 
FROM
	tbl_exam,
	(
	SELECT
		max(tbl_id) id,
		studyid 
	FROM
		tbl_exam 
	GROUP BY
		studyid
	HAVING
		count( * ) > 1 
	) t2 
WHERE
	tbl_exam.studyid = t2.studyid 
	AND tbl_exam.tbl_id < t2.id