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

8 votes138 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote174 views1 answer
Sql server system messeges
SQL
1 vote132 views1 answer
Quit mysql
SQL
0 vote235 views1 answer
Python get backup of sql
SQL
1 vote128 views1 answer
Select random sample sql
SQL
-1 vote120 views1 answer
Ssms connect with connection string
SQL
0 vote176 views1 answer
Alternative for LIMIT sql
SQL
0 vote166 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote142 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote142 views1 answer
Excel vba import data to sql server
SQL