We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
It works same as 'COALESCE()' which just replaces the 'NULL' value with the value specified.
For eg. above 'ifnull(SUM(total_submissions),0)' could be written as 'COALESCE(SUM(total_submissions),0)' which means if no NULL is present in the row, give output as SUM(total_submissions) and if NULL is present, it will replace it as 0.
Interviews
You are viewing a single comment's thread. Return to all comments →
It works same as 'COALESCE()' which just replaces the 'NULL' value with the value specified.
For eg. above 'ifnull(SUM(total_submissions),0)' could be written as 'COALESCE(SUM(total_submissions),0)' which means if no NULL is present in the row, give output as SUM(total_submissions) and if NULL is present, it will replace it as 0.