0 votes
in Technology by (55.6k points)
What is COALESCE in SQL Server?

1 Answer

0 votes
by (55.6k points)
What is COALESCE in SQL Server?

COALESCE is used to return first non-null expression within the arguments. This function is used to return a non-null from more than one column in the arguments.

Example –

Select COALESCE(empno, empname, salary) from employee;
...