Case when else if

    teradata case when in select
    teradata case statement in select
    teradata case when in list
    teradata case example
  • Teradata case when in select

    • Teradata case statement in where clause

  • Teradata case statement in where clause
  • Teradata case statement
  • Teradata case when multiple conditions
  • Teradata case when in list
  • Nested case statement in teradata

    • Teradata case when multiple conditions!

    Teradata - CASE and COALESCE

    This chapter explains the CASE and COALESCE functions of Teradata.

    CASE Expression

    CASE expression evaluates each row against a condition or WHEN clause and returns the result of the first match.

    If there are no matches then the result from ELSE part of returned.

    Syntax

    Following is the syntax of the CASE expression.

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

    Example

    Consider the following Employee table.

    EmployeeNoFirstNameLastNameJoinedDateDepartmentNoBirthDate
    101MikeJames3/27/200511/5/1980
    102RobertWilliams4/25/200723/5/1983
    103PeterPaul3/21/200724/1/1983
    104AlexStuart2/1/2008211/6/1984
    105RobertJames1/4/2008312/1/1984

    The following example evaluates the DepartmentNo column and returns value of 1 if the department number is 1; returns 2 if the department number is 3; otherwise it returns value as invalid department.

    SELECT EmployeeNo, CASE DepartmentNo WHEN 1 THEN 'Admin' WHEN 2 THE

      teradata month difference
      teradata select case when else