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 vote199 views1 answer
Psql get table data types
SQL
0 vote292 views1 answer
Linux upload database to mysql
SQL
4 votes231 views2 answers
Postgresql float data type
SQL
2 votes188 views1 answer
Postgresql update sequence next value
SQL
0 vote202 views1 answer
Postgresql update to unique
SQL
0 vote189 views1 answer
Monthly Birthday SQL Query
SQL
0 vote197 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
6 votes199 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote184 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote211 views2 answers
Mysql dump structure only
SQL