What is COALESCE in SQL Server?

Report
Question
10 views

Please explain why do you think this question should be reported?

Report Cancel

COALESCE function returns the first non-null expression in the list. If all expressions evaluate to null, then the COALESCE function will return null.Example:-
Select COALESCE(name, rollnumber, class) from student;

Please follow and like us:

About the Author