What is the difference between COALESCE() & ISNULL()?

Q 35. What is the difference between COALESCE() & ISNULL()?

Ans : COALESCE(): COALESCE function in SQL returns the first non-NULL expression among its arguments.

If all the expressions evaluate to null, then the COALESCE function will return null.

Syntax:

SELECT column(s), CAOLESCE(expression_1,....,expression_n) FROM table_name;

ISNULL(): The ISNULL function has different uses in SQL Server and MySQL.

In SQL Server, ISNULL() function is used to replace NULL values.

Syntax:

SELECT column(s) , ISNULL(column_name,value_to_replace)  FROM table_name;

Donate to  grow Studyandupdates

स्टडीएंडअपडेट्स को विकसित करने के लिए  मदत करें

To Provide  more Services among Student

छात्र के बीच अधिक से अधिक  सेवाएं प्रदान करने के लिए