COALESCE – Collating the Essence30 Mar 2015Krishna COALESCE It is used to check if the argument is NULL, if it is NULL then it takes the …