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 vote179 views1 answer
Template MySQL Zabbix agent
SQL
0 vote180 views2 answers
Select last 30 days sql
SQL
0 vote171 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote191 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote164 views1 answer
Add multiple field in table sql
SQL
6 votes169 views1 answer
Update left join mysql
SQL
0 vote206 views1 answer
Sql from null to not null
SQL
-1 vote167 views1 answer
Round up and down sql
SQL
32 votes164 views6 answers
Insert select
SQL
2 votes164 views1 answer
How to find constraints on a table in oracle
SQL