Differences between COALESCE and NULLIF

COALESCE	NULLIF
It Accepts N Parameters, It returns first Not Null Values For Example:- select coalesce(NULL,2,NULL,3) Output :- 2	It Accepts 2 Parameters, if both are not equal then it will return first value. For Example:- SELECT NULLIF(1,2) Output :- 1
First argument can be NULL, but both argument can not NULL value	First argument can not be NULL input
If Both argument are equal, then it will return first value. For Example:- SELECT NULLIF(2,2) Output :- 2	If Both argument are equal, then it will return NULL value. For Example:- SELECT NULLIF(2,2) Output :- NULL