Õâ¸ösqlÓï¾ä Ôõôд£¿

A±í

id  name  fen 

1  java  60
2  C#    70
3  php    50


½á¹ûÕâÑùµÄ


id  name  fen  pass

1  java  60    ͨ¹ý
2  C#    70    ͨ¹ý
3  php    50  δͨ¹ý

---

select id,name,fen,decode(sign(fen-60),1,'ͨ¹ý',0,'ͨ¹ý',-1,'δͨ¹ý') pass
from a;

---

SQL code:

alter table a add pass nvarchar2(20);

update a
set pass=case when fen>=60 then 'ͨ¹ý'
else 'δͨ¹ý'
end

---

select id,name,fen,decode(sign(fen-60),-1,'δͨ¹ý'£¬'ͨ¹ý') as pass from A;

---

SQL code:

SQL>
SQL> with A as(
2 select 1 id, 'java' name, 60 fen from dual union all
3 select 2 id, 'C#' name, 70 fen from dual union all
4 select 3 id, 'php' name, 50 fen from dual
5 )
6 select id,name,fen,case when fen>=60 then 'ͨ¹ý' else 'δͨ¹ý' end pass from A
7 /

ID NAME FEN PASS
---------- ---- ---------- ---------
1 java 60 ͨ¹ý
2 C#