Real life Example of Coalesce() function
Long Answer
Views 1436
Answer:
According to the MSDN Books online COALESCE() returns the first Non NULL value. Let's understand this with an example.
Consider the Employees Table below. Not all employees have their First, Midde and Last Names filled. Some of the employees has First name missing,
Related Articles:
This section is dedicated exclusively to Questions & Answers. For an in-depth exploration of SQL, click the links and dive deeper into this subject.
Join Our telegram group to ask Questions
Click below button to join our groups.