Avatar of jose11au
Flag for Australia

asked on 

SQL - Data quality records that are missing addresses

Hi All,

Could I please ask if this query is correct?

Basically I am looking for data quality issues where a record is missing address details. If either address_1, address_2 or address_3  is populated then the record is okay.

select  *
from Sales
where address_1 Is Null or address_2 Is Null or address_3 Is Null
First_name is not null or Last_name is not null

Open in new window

SQLMicrosoft SQL Server

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon