What is Coalesce?

 Posted by Rajni.Shekhar on 4/13/2012 | Category: Sql Server Interview questions | Views: 2183 | Points: 40

Coalesce is a function tat returns first non-null value within the given list of values.


select param1, param2, Coalesce(param1*param2) from tableName;

It will receive only non-null value from param1 and param2

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response