Tech Diary
July 27, 2015
Case statement in Where clause
where x = 1
and
(
case when y in ('O', 'P', 'H') then 'A'
else 'I'
end
) = 'I'
and z = 4
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment