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
SELECT newsid, news,STATUS,


                case STATUS


         WHEN '1' THEN 'Active'


          WHEN '0' THEN 'Deactive'


        END AS fieldnm


FROM news ORDER BY newsid;