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 vote107 views1 answer
Parsing float to int in mysql
SQL
0 vote117 views1 answer
Where date in datetime mysql
SQL
0 vote132 views1 answer
Flush user resource mysql
SQL
2 votes130 views1 answer
How to insert string variable into sqlite database
SQL
0 vote124 views1 answer
Find and replace database table phpmyadmin
SQL
3 votes128 views1 answer
Postgres kill running query
SQL
0 vote117 views1 answer
How to drop columns with constraint from a table in sql script
SQL
39 votes121 views5 answers
Sql drop column
SQL
15 votes125 views4 answers
Sql update from select
SQL
4 votes121 views4 answers
Oracle tablespace tables list
SQL