Sql delete where in

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

Sql delete where in

-- Deletes all records where `columnName` matches the values in brackets.
DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');

Sql delete

DELETE FROM computer WHERE name = '{}'

Source: futurelearn.com

Similar codes

0 vote361 views1 answer
Migrations.RunSQL
SQL
1 vote398 views1 answer
T-sql find object by name
SQL
0 vote304 views1 answer
Finish transaction sql
SQL
1 vote345 views1 answer
Mysql show data from table
SQL
0 vote359 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
37 votes367 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
11 votes401 views2 answers
Mysql disable safe mode
SQL
0 vote376 views1 answer
Mysql grant grant option
SQL
0 vote349 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote382 views1 answer
Sql date time query find
SQL