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

0 vote303 views1 answer
Mysql Error Code: 1005
SQL
15 votes424 views5 answers
Select all tables sql
SQL
6 votes337 views2 answers
Difference between join vs union
SQL
1 vote348 views1 answer
Nvl postgres
SQL
0 vote319 views1 answer
Get who is hired in month in sql
SQL
0 vote309 views1 answer
Equi joins in oracle
SQL
0 vote309 views1 answer
Contact mysql column field
SQL
2 votes331 views1 answer
Oracle list duplicates
SQL
0 vote320 views1 answer
Mac os zsh: command not found: mysql
SQL
16 votes324 views4 answers
Ascending order mysql
SQL