Answers for "sql count null as 0"

sql count null as 0

SELECT sum(CASE WHEN column_A IS NULL THEN 1 ELSE 0 END) A,
       sum(CASE WHEN column_B IS NULL THEN 1 ELSE 0 END) B
FROM my_table;

Posted by: Guest on April-21-2021

Code answers related to "sql count null as 0"