Delete from IN subquery

DELETE e.*
FROM tableE e
WHERE id IN (SELECT id
             FROM (SELECT id
                   FROM tableE
                   WHERE arg = 1 AND foo = 'bar') x);

Source: stackoverflow.com

Similar codes

2 votes322 views1 answer
Set auto increment from 1
SQL
2 votes328 views5 answers
Install postgresql 10 centos 7
SQL
6 votes304 views2 answers
Join vs union
SQL
0 vote293 views1 answer
Select only one row sql
SQL
0 vote340 views1 answer
Psql check table fields
SQL
-1 vote324 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
20 votes305 views4 answers
Sqlite create table if not exists
SQL
1 vote340 views1 answer
Homebrew install mysql
SQL
28 votes306 views4 answers
Show tables mysql
SQL
4 votes260 views3 answers
Create table if not exists postgresql
SQL