sql delete rows where code example
Example 1: 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'));
Example 2: deleting row in sql
delete from TableName where condition;
delete from scrumteam where firstname='Jack';
delete from scrumteam where JobTitle='SDET';
Example 3: sql delete where in
DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');