I have a code where i have this statement
x
when d.ID in (1,2,3,4,5,6,7,8)
then
case
when d.today < '01/01/2001'
then
122
else
124
end
end,
case
when d.today < '10/10/2018'
then
121
ELSE
125
end
end
case statement is throwing an error saying incorrect syntax, what i am missing here can’t seem to get it
Advertisement
Answer
Check This-
CASE
WHEN d.ID IN(1, 2, 3, 4, 5, 6, 7, 8)
THEN
CASE
WHEN d.today < '01/01/2001' THEN 122
ELSE 124
END
ELSE
CASE
WHEN d.today < '10/10/2018' THEN 121
ELSE 125
END
END;