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
原创
2021-07-24 21:28:41 ·
67 阅读 ·
0 评论