remove all NULL valued rows from table?

Question

My sql query working fine but i have another issue some rows in my table have NULL values. i want to remove all NULL valued rows. Any recommendations?

Answer 1

Delete statement should work

DELETE FROM your_table 
WHERE your_column IS NULL;

In case of multi column NULL check, I suggest using COALESCE

DELETE FROM your_table 
WHERE COALESCE (your_column1, your_column2, your_column3 ) IS NULL;

Answer 2

If you want to delete a row where all columns values are null then use following query to delete:

    DELETE FROM your_table 
    where your_column1 IS NULL 
    AND your_column2 IS NULL 
    AND your_column3 IS NUL;

But if you want to delete a row where any column value is null then use following query to delete:

    DELETE FROM your_table 
    where your_column1 IS NULL 
    OR your_column2 IS NULL 
    OR your_column3 IS NUL;