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 vote118 views1 answer
Oracle lock user
SQL
1 vote139 views1 answer
How to show index type in postgresql
SQL
0 vote148 views1 answer
"Hello User Name"
SQL
0 vote131 views1 answer
Initcap in mysql
SQL
0 vote146 views1 answer
How to insert same table data using mysql query
SQL
0 vote140 views1 answer
Alter table change default
SQL
4 votes121 views1 answer
SQL order random
SQL
12 votes135 views5 answers
Rename table in mysql
SQL
0 vote133 views1 answer
Mysql sql.gz
SQL
4 votes133 views1 answer
Data types in sql
SQL