Working with Nulls & Coalesce

Posted in | at 7:50 AM

we cannot use (=) to evaluate some value to null

Have to use IS NULL


**** Coalesce Function ***

Ex :

Select coalesce(null, 1+null, 1+2, 'xx') -> output=3

Read Users' Comments (0)

0 Response to "Working with Nulls & Coalesce"

Post a Comment

Subscribe to: Post Comments (Atom)