/ Published in: SQL
Checking for null value and assigns a default value if the field is null
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT COALESCE(age,0) FROM employee