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:
SELECT
COMPANY,
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
FROM SAMPLES.COMP_DETL
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.
Comments
Post a Comment