What coalesce does in SQL?

What coalesce does in SQL?

Coalesce function is used for returns the first non-NULL expression among its arguments.
In SQL Server, the ISNULL( ) function is used to replace NULL value with another value.
SELECT COALESCE(NULL, NULL, NULL, 'Helloworld.com', NULL, 'Dotenttricks.com');

Post a Comment

2 Comments