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

0 vote264 views1 answer
Write sql query to show the details start from digit
SQL
11 votes275 views4 answers
MYSQL LOGIN
SQL
1 vote268 views1 answer
Sql padd let with zeros
SQL
0 vote226 views1 answer
Flask_sqlalchemy install
SQL
0 vote254 views1 answer
Grant access on table in oracle
SQL
0 vote262 views1 answer
Join in update query in mysql
SQL
3 votes309 views2 answers
Oracle drop sequence
SQL
0 vote249 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote285 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote266 views1 answer
Connexion mysql
SQL