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 vote172 views1 answer
Delete data from database sqlite android
SQL
7 votes157 views6 answers
Reset identity column in sql server
SQL
0 vote166 views2 answers
How to update date in oracle
SQL
6 votes177 views1 answer
Sqlite foreign key
SQL
0 vote257 views1 answer
Mysql readable output
SQL
0 vote190 views1 answer
How to get nth number in sql
SQL
0 vote154 views1 answer
Dnsmasq.conf location macos
SQL
1 vote162 views1 answer
How to get mysql db size
SQL
4 votes163 views1 answer
Datepart postgres
SQL
0 vote222 views1 answer
Show all mongodb
SQL