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

5 votes170 views1 answer
Oracle scan source ddl
SQL
3 votes189 views1 answer
Async await mysql nodejs
SQL
1 vote167 views1 answer
Count mysql server db tables
SQL
1 vote168 views1 answer
Postgres format date in select
SQL
2 votes181 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
1 vote227 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote175 views1 answer
Cross apply top for each row t1
SQL
0 vote199 views1 answer
Mysql relationships between tables
SQL
0 vote191 views1 answer
Sqlite löschen einer tabelle
SQL
3 votes178 views1 answer
Pl sql escape &
SQL