In Teradata, what is the purpose of using CASE Expression?

1.	In Teradata, what is the purpose of using CASE Expression?
Answer» When a CASE expression is used, each row is compared with a CONDITION or WHEN CLAUSE, and the result of the first MATCH is returned. Else, the result from the ELSE clause will be returned if there are no matches. Syntax: CASE <expression> WHEN <expression> THEN result-1 WHEN <expression> THEN result-2 ELSE Result-n END

Answer»

When a CASE expression is used, each row is compared with a CONDITION or WHEN CLAUSE, and the result of the first MATCH is returned. Else, the result from the ELSE clause will be returned if there are no matches.

Syntax:

CASE <expression> WHEN <expression> THEN result-1 WHEN <expression> THEN result-2 ELSE Result-n END

Discussion

No Comment Found

Related InterviewSolutions

What's the purpose of this below query?
What is the importance of UPSERT command in Teradata?
In Teradata, what is the purpose of using CASE Expression?
Explain the set operators in Teradata.
How to find duplicate records in a table?
Explain fallback in Teradata.
List out the different forms of locks available in Teradata.
What is PPI (Partitioned Primary Index)?
What is PDE (Parallel Data Extension)?
List some of the most commonly used BTEQ scripts.

In Teradata, what is the purpose of using CASE Expression?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment