delete from in subquery

Solutions on MaxInterview for delete from in subquery by the best coders in the world

showing results for - "delete from in subquery"
Amy
04 Mar 2019
1DELETE e.*
2FROM tableE e
3WHERE id IN (SELECT id
4             FROM (SELECT id
5                   FROM tableE
6                   WHERE arg = 1 AND foo = 'bar') x);
7