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

-1 vote294 views1 answer
Mysql faster insert
SQL
10 votes289 views1 answer
Oracle view dependencies
SQL
0 vote257 views1 answer
In mysql workbench contnent not feching
SQL
0 vote288 views1 answer
Oracle current date minus 1 day
SQL
0 vote261 views1 answer
Using distinct and count together in sql
SQL
0 vote904 views1 answer
Mysql custom sort order
SQL
0 vote309 views1 answer
Snowflake drop column
SQL
0 vote272 views1 answer
How to add unique key constraint in mysql
SQL
14 votes298 views3 answers
How to add default constraint in mysql
SQL
1 vote263 views1 answer
Decalre temp table sql
SQL