February 4

0 comments


What is the purpose of the Teradata COALESCE function?

COALESCE receives a list of scalars as arguments and returns the first value that is not NULL. If all scalars are NULL COALESCE returns NULL.

What is the syntax of the Teradata COALESCE function?

SELECT COALESCE(skalar1, skalar2, skalar3,…,skalarN) FROM Customer;

Is there an alternative to the Teradata COALESCE function?

The COALESCE function is a simplified option for the following CASE statement:

SELECT
CASE
WHEN skalar1 IS NOT NULL THEN skalar1
WHEN skalar2 IS NOT NULL THEN skalar2
..
WHEN skalarN IS NOT NULL THEN skalarN
ELSE NULL
END
FROM Customer;

Which data types cannot be used as scalars in Teradata COALESCE or can only be used to a limited extent?

BLOB scalars must be cast to BYTE or VARBYTE.
Scalars of the type CLOB must be cast to CHAR or VARCHAR.
Several UDT scalars must all be of the same type.

Is the COALESCE function ANSI Compliant?

Yes, it is ANSI SQL:2011 compliant.

DWH Pro Admin


Teradata and Data Warehouse Specialist with more than 20 years of experience

You might also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Never miss a good story!

 Subscribe to our newsletter to keep up with the latest trends!

>