Every derived table must have its own alias

Every derived table must have its own alias（数据库执行）

删除表中数据时出现报错，使用的语句如下

DELETE 
FROM
	Person b 
WHERE
	b.id NOT IN ( SELECT min( id ) Id FROM Person a GROUP BY a.Email )

出现第一次报错 You can’t specify target table ‘b’ for update in FROM clause

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

问题原因见这篇文章

也就是说将select出的结果再通过中间表select一遍，这样就规避了错误。注意，这个问题只出现于mysql，mssql和Oracle不会出现此问题。
You can’t specify target table for update in FROM clause含义:不能在同一表中查询的数据作为同一表的更新数据。

更具博客内容更改了相关语句

DELETE 
FROM
	Person b 
WHERE
	b.id NOT IN (
	SELECT
		Id 
	FROM
	( SELECT min( id ) Id FROM Person a GROUP BY a.Email ) 
	)

更改后出现第二次报错：Every derived table must have its own alias

问题原因见这篇文章

在做多表查询，或者查询的时候产生新的表的时候会出现这个错误：Every derived table must have its own alias（每一个派生出来的表都必须有一个自己的别名）。

最后更改为

DELETE 
FROM
	Person 
WHERE
	Id NOT IN (
	SELECT
		Id 
	FROM
	( SELECT min( id ) Id FROM Person a GROUP BY a.Email ) t 
	)

正常运行