rajakumar_na

 Profile Answers by rajakumar_na 

• Nov 12th, 2007

 

CASE expr WHEN comparison_expr1 THEN return_expr1

[WHEN comparison_expr2 THEN return_expr2

WHEN comparison_exprn THEN return_exprn

ELSE else_expr]

END

sirisha.hari

 Profile Answers by sirisha.hari 

• Jan 6th, 2008

 

 

hi,

select sno,sname,
(case  when total>50
then 'good'
when total>35 and total<50
then 'average'
else
  'fail'
end)result

from student_result

AVADHESH

• Sep 30th, 2011

 

Code
span style="color: #ff0000;">'1' THEN 'Active'


          WHEN '0' THEN 'Deactive'