/ 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
Comments
