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 vote135 views1 answer
View t-sql mail configuration
SQL
25 votes175 views5 answers
Mysql replace text
SQL
0 vote143 views1 answer
Python connect microsoft sql server
SQL
4 votes200 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote225 views1 answer
Mysql monthname
SQL
0 vote144 views1 answer
Postgresql if else endif
SQL
5 votes171 views2 answers
Add days in oracle sql
SQL
1 vote142 views1 answer
Return size of tables in mysql
SQL
49 votes213 views6 answers
Get duplicate records in sql
SQL
3 votes141 views1 answer
Pl sql escape &
SQL