We help IT Professionals succeed at work.

Delete all records with Null in column

pda4me
pda4me asked
on
I have a table called LISTINGS that has a column called Street_Number and Street_Name

What is the SQL query to remove any records that are Null when both of these columns are null in the table
Comment
Watch Question

CERTIFIED EXPERT
Commented:
delete from Listings where Street_number is null and Street_name is null

Author

Commented:
thanks!~