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 vote125 views2 answers
Get item by composite primary key mysql
SQL
-1 vote145 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote109 views1 answer
Get who is hired in specific month in sql
SQL
0 vote113 views1 answer
Nth max in my sql
SQL
0 vote180 views1 answer
Mysql update table from select on another table
SQL
0 vote123 views1 answer
Mysql set boolean default value
SQL
0 vote233 views1 answer
Sqlite display data in separated columns
SQL
0 vote121 views1 answer
Like date sql server not working
SQL
0 vote153 views5 answers
How to make trigger in phpmyadmin
SQL
2 votes116 views5 answers
Tablespace ORACLE
SQL