Teradata SQL - COALESCE and NULLIF Functions
more_vert
COALESCE function in Teradata returns NULL if all arguments evaluate to null; otherwise it returns the value of the first non-null argument. NULLIF is to used evaluate two expressions and returns NULL if the two arguments are equal otherwise if returns the first arguments. IS NULL is used to examine whether one expression is null or not.
COALESCE code snippet
-- returns 1 select coalesce(1,2,null); -- returns 2 select coalesce(null,2,null);
NULLIF code snippet
-- returns d as not equal select nullif('d','e'); -- returns null as values are equal select nullif('2',2); -- returns null as values are equal select nullif('abc','abc');
IS NULL code snippet
-- returns 2 select case when 'e' is null then '1' else '2' end;
copyright
This page is subject to Site terms.
comment Comments
No comments yet.
Log in with external accounts
warning Please login first to view stats information.