寻找组合2个SQL查询的最佳方法[重复]

Question

select id from table1 where id_hash IN( select id_hash from table1 where name='stack' group by id_hash having count(*)>1

将上面SELECT的输出(id)传递给DELETE

delete from table1 where id in (<id from SELECT>)

提前谢了。

Answer 1

以下是问过类似问题的人的链接：

如何在WHERE子句中使用SELECT语句编写SQL DELETE语句？

下面是这个线程的一个例子。归功于用户@Alexw

DELETE FROM tableA
WHERE ROWID IN 
  ( SELECT q.ROWID
    FROM tableA q
    INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) OR q.memotext NOT LIKE '%/%/%')
    AND (u.FldFormat = 'Date'));