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 vote199 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote225 views1 answer
Sql character index
SQL
2 votes174 views1 answer
Create table with primary key
SQL
2 votes170 views1 answer
Oracle create directory
SQL
2 votes189 views2 answers
Mysql limit
SQL
0 vote183 views1 answer
Mysql repair a table
SQL
4 votes177 views1 answer
Add constraint fk
SQL
2 votes206 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
3 votes184 views2 answers
Truncate all tables
SQL
0 vote186 views1 answer
Tsql cmd exec script from file
SQL