Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to delete records that equal to Null in multiple columns. Let’s get started
In the caption below, we can see that we have NULL values in Order Date and Ship Date columns
To delete the transaction records that equals to NULL
Execute the queries:
delete from [Unique 1M Data] where [Order Date] is null
delete from [Unique 1M Data] where [Ship Date] is null
From the caption below, we that see that the NULL has been deleted from the Table.