Sql delete where in select

DELETE FROM tableA
WHERE ROWID IN 
  ( SELECT q.ROWID
    FROM tableA q
      INNER JOIN tableB u on (u.qlabel = q.entityrole AND u.fieldnum = q.fieldnum) 
    WHERE (LENGTH(q.memotext) NOT IN (8,9,10) OR q.memotext NOT LIKE '%/%/%')
      AND (u.FldFormat = 'Date'));

Source: stackoverflow.com

Similar codes

1 vote118 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote131 views1 answer
Create synonym for dblink in oracle
SQL
0 vote142 views1 answer
Laravel migration sql dump
SQL
3 votes122 views1 answer
Start mysql server linux terminal
SQL
11 votes144 views2 answers
Sql rank
SQL
0 vote137 views1 answer
Postgresql if else endif
SQL
5 votes157 views1 answer
Oracle generate list of dates in between a date range
SQL
10 votes135 views1 answer
Oracle dba_dependencies
SQL
0 vote137 views2 answers
Zsh: command not found: mysq
SQL
2 votes142 views1 answer
Oracle list grants on procedure
SQL