本文探讨了在SQL中如何使用子查询进行删除操作，特别提到了错误`Every derived table must have its own alias`，并提供了修正该错误的正确代码示例。内容涉及数据库表的删除规则以及子查询在删除操作中的应用。
delete from Person where Id not in (select * from (select Min(Id) from Person Group by Email))
这样写报错：Every derived table must have its own alias
错误原因：
中间表必须指定别名
正确写法
delete from Person where Id not in (select * from (select Min(Id) from Person Group by Email) as e)
扫一扫
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
