What is coalesce function?

This function returns the first non null value from the parameters and if the given parameter has all the null values then null will be returned. Now have a look at the following example.

SELECT COALESCE(NULL, NULL, 'blogspot.com', NULL, 'i am sai');
Result: 'blogspot.com'