MySQL Coalesce - selects non- null value

by Nirmala 2010-01-08 13:54:09

MySQL Coalesce
It selects the first non-null value of its arguments.
Syntax:
coalesce(value,..):
It returns the first non NULL value in the list. If there are no non-NULL values then it returns NULL.

Tagged in:

1324
like
1
dislike
0
mail
flag

You must LOGIN to add comments