Answers for "how to check if any column is null in sql"

sql not null

SELECT column_name FROM table_name 
WHERE column_name IS NOT NULL;

Posted by: Guest on December-07-2020

if column value is null then in mysql

SELECT 
    contactname, IFNULL(bizphone, homephone) phone
FROM
    contacts;

Posted by: Guest on November-05-2020

Code answers related to "how to check if any column is null in sql"