Different ways to SQL delete duplicate rows from a SQL Table

Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

SQL Server MERGE to insert, update and delete at the same time

SQL DELETE Statement (Transact SQL) - Essential SQL

SQL DELETE Statement Examples and Best Practices

Overview of the SQL Delete statement

Working with SQL NULL values

Join SQL Server tables where columns include NULL values

How to Use SQL Server Coalesce to Work with NULL Values