To create a Teradata SQL query with a case condition that checks the ID and its starting date, follow these steps:
SELECT column1, column2, column3 FROM table1 JOIN table2 ON table1.ID = table2.ID WHERE ...
CASE WHEN condition THEN value1 WHEN condition THEN value2 ELSE value3 END
CASE WHEN table1.ID = 12345 AND table1.start_date >= '2021-01-01' THEN 'Active' ELSE 'Inactive' END as status
SELECT column1, column2, column3, CASE WHEN table1.ID = 12345 AND table1.start_date >= '2021-01-01' THEN 'Active' ELSE 'Inactive' END as status FROM table1 JOIN table2 ON table1.ID = table2.ID WHERE ...
Asked: 2023-06-01 07:38:24 +0000
Seen: 19 times
Last updated: Jun 01 '23