DELETE FROM table_name WHERE condition;
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'));
-- Deletes all records where `columnName` matches the values in brackets. DELETE FROM tableName WHERE columnName IN ('val1', 'val2', 'val3');
DELETE FROM table_name /* delete all from the table */