WITH子句是SELECT的语法，不能和DELETE使用。更多信息请参考WITH子句。

with必须紧跟引用的select语句，而不是delete,update,merge等,代码如下：
update dest b set b.NAME=(
with t as
(
select * from temp
)
select a.NAME from temp a where a.ID=b.ID
)

PostGreSQL

WITH x AS ( SELECT col1, Min(ctid) AS min FROM rohilla GROUP BY col1 HAVING Count(col1) > 1 ) DELETE FROM rohilla b using x WHERE x.col1 = b.col1 AND x.min <> b.ctid;

Mysql With语句不可以