输出
方法1:select sno,cno,score,case when score>=60 then 'pass' else 'fail' end 结果 from sc;
方法2:select sno,cno,score,decode (sign(score-60),-1,'fail','pass') 结果 from sc;
输出
方法1:select sno,cno,score,case when score>=60 then 'pass' else 'fail' end 结果 from sc;
方法2:select sno,cno,score,decode (sign(score-60),-1,'fail','pass') 结果 from sc;