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 vote222 views1 answer
Add sqlcmd to path linux
SQL
0 vote229 views1 answer
Query by column for substring sql
SQL
11 votes233 views2 answers
Oracle saurce code
SQL
0 vote222 views1 answer
SQL FROM-Klausel
SQL
3 votes211 views1 answer
Sql set null
SQL
0 vote327 views1 answer
Postgresql powershell query
SQL
0 vote225 views1 answer
Mysql where in keep order
SQL
0 vote206 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
2 votes248 views1 answer
Oracle run_duration to number
SQL
0 vote226 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL