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 vote277 views1 answer
How to find median of a column sql
SQL
-1 vote285 views1 answer
Extract Data from SQL Server into XML Format
SQL
-1 vote308 views1 answer
How to reset autoincrement in sqlite java
SQL
1 vote290 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote267 views1 answer
How to find database collation in postgres
SQL
0 vote285 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
4 votes280 views1 answer
Create db table
SQL
5 votes278 views2 answers
Oracle rename table
SQL
3 votes267 views1 answer
Mysql load sql from file
SQL
0 vote273 views1 answer
Sql server count all tables rows
SQL