Please, try to help with this. I use case statement but for 2 arguments.
Down here is the idea of what i want to get:
select x case x
when x = 'AB' and y like 'CD%' then x= 'CD'
when x = 'ZZ' and y like 'CC%' then x= 'BA'
when x in ('bbb','sss','ddg') then x= 'BB'
I ll be grateful if anyone would help write right querry.
Thank in advance
Marcel