/ Published in: SQL

Checking for null value and assigns a default value if the field is null
Expand |
Embed | Plain Text
SELECT coalesce(age,0) FROM employee
You need to login to post a comment.
Checking for null value and assigns a default value if the field is null
SELECT coalesce(age,0) FROM employee
You need to login to post a comment.