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

21 votes219 views4 answers
Add column mssql
SQL
0 vote227 views1 answer
Sql query wordpress export post
SQL
0 vote322 views1 answer
How to get table current identity value in sql server
SQL
0 vote199 views1 answer
C# mysql update statement set value to null
SQL
1 vote209 views2 answers
Sql server concat string and int
SQL
0 vote255 views1 answer
Mysl like insert a variable
SQL
28 votes205 views6 answers
Mysql change user password
SQL
0 vote183 views1 answer
Get who is hired in month in sql
SQL
5 votes208 views1 answer
Oracle get nls settings
SQL
32 votes218 views6 answers
How to change column name in sql
SQL