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 vote331 views1 answer
Select inside insert query
SQL
3 votes320 views1 answer
Oracle apex message quit website
SQL
0 vote347 views2 answers
Search stored procedures by name
SQL
0 vote407 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote326 views1 answer
Mysql workbench not showing schemas
SQL
0 vote337 views1 answer
Sql server union if table exist
SQL
4 votes345 views3 answers
Employee name starting with in sql
SQL
0 vote335 views1 answer
Mysql update from n to 100
SQL
-1 vote333 views1 answer
Sql set max value in column
SQL
0 vote327 views1 answer
Sql server split string and insert into table select
SQL