How to write best CASE example in Teradata SQL
|Teradata Case Statement|
- CASE will provide logical control of the SQL. In CASE statement we can give >,<,=,<>
- The CASE has structure it starts with CASE and end with END
See an example of Advanced CASE:
WHEN DEPT_NO = 1 THEN 'HR'
WHEN DEPT_NO = 2 THEN 'IT'
WHEN DEPT_NO = 3 THEN 'FINANCE'
ELSE 'I DON''T KNOW'
END AS DEPT_NAME
ORDER BY 1;
The above query covered all like ELSE, THEN, WHEN, CASE and END. This is the best example how typically,you can write CASE in an SQL query for logical validation.