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

5 votes196 views3 answers
Oracle list columns in schema
SQL
1 vote178 views1 answer
Import in mysql without a software
SQL
28 votes197 views4 answers
Show tables mysql
SQL
0 vote197 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
8 votes158 views8 answers
Second highest salary in mysql
SQL
2 votes203 views2 answers
Mysql find max value row
SQL
2 votes247 views1 answer
Create delete procedure mysql
SQL
0 vote186 views1 answer
Dapper run sql script with parameters
SQL
0 vote193 views1 answer
Mysql coonect sample code
SQL
0 vote194 views2 answers
Return the number of records in a single table mysql
SQL