case when

Reply
N/A
Posts: 1

case when

I have the next code:

"case when t1.AGB_instelling = '1.06' then Key_spec='03.05'

when t1.AGB_instelling = '1.07' then Key_spec='03.06'

end

For eacht AGB_instelling there are N Key_spec, for the two mentioned AGB_inst. I want the mentioned Key_spec but for other AGB_instellingen I don't care. But in the results I only found the two mentioned AGB_instellingen and no other. How can this be solved?

Super User
Posts: 17,819

Re: case when

Else.

case when t1.AGB_instelling = '1.06' then Key_spec='03.05'

when t1.AGB_instelling = '1.07' then Key_spec='03.06'

else key_spec="dont care"

end

Super Contributor
Posts: 578

Re: case when

reeza always beats me to the answer...

Super Contributor
Posts: 578

Re: case when

you should use the else clause to specify what should happen.

case

     when t1.AGB_instelling = '1.06' then Key_spec='03.05'

     when t1.AGB_instelling = '1.07' then Key_spec='03.06'

     else ????

end

Ask a Question
Discussion stats
  • 3 replies
  • 157 views
  • 0 likes
  • 3 in conversation