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 vote322 views2 answers
Mysql regexp match word
SQL
3 votes303 views3 answers
Mysql select table names
SQL
0 vote345 views1 answer
Mysql zerofill
SQL
4 votes313 views1 answer
Oracle delete last row
SQL
0 vote321 views1 answer
Windows services sql
SQL
5 votes328 views1 answer
JBDC
SQL
0 vote286 views1 answer
Get only first row mysql
SQL
0 vote342 views1 answer
Alter boolean column postgresql
SQL
0 vote270 views2 answers
Jupyter notebook connect to database
SQL
2 votes283 views1 answer
Oracle sql drop column if exists
SQL