SQL Delete Syntax

Simple Delete:

DELETE FROM TableName
WHERE some_column=some_value

Delete NULL Values:

DELETE FROM TableName
WHERE some_column IS NULL

Delete NULL and Empty String Values:

DELETE FROM TableName
WHERE COALESCE(some_column, '') = ''

Delete with values from separate table:

DELETE FROM TableName
WHERE some_column IN
  (SELECT TableId FROM TableName2
WHERE TableName2ColumnId = value)