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 vote300 views1 answer
Round up and down sql
SQL
0 vote285 views1 answer
Postgres enumerated type
SQL
0 vote313 views1 answer
SQL: calculate hours from two dates
SQL
0 vote291 views1 answer
Sql select max value for each group
SQL
5 votes300 views1 answer
Mysql last day of next month
SQL
0 vote285 views1 answer
Oracle db get table sizes
SQL
10 votes289 views1 answer
Oracle object dependencies
SQL
0 vote272 views1 answer
Mariadb LOAD DATA INFILE
SQL
1 vote283 views1 answer
Mysql f# examples
SQL
0 vote349 views1 answer
Generate a random otp in sql server
SQL