Çó½ÌÒ»¸öoracle±à³ÌÌâ.... - Oracle / ¿ª·¢

±íA:
name fenshu
a 80
b 44
c 60
d 78

°´ÕÕ·ÖÊý´óÓÚ80ÓÅÐã,60-80ºÏ¸ñ,60ÒÔϲî
Ôõôת»»³ÉÏÂÁÐÑù×Ó.Ò»¾äsql
±íB  
name fenshu XX
a 80 ÓÅÐã
b 44 ²î
c 60 ºÏ¸ñ
d 78 ºÏ¸ñ

---

SQL code:
select name,fenshu,case when fenshu between 60 and 80 then "ºÏ¸ñ" when fenshu < 60 then "²î" else "ÓÅÐã" end xx
from a;

---

SQL code:

select name,fenshu,
case when fenshu>=80 then 'ÓÅÐã'
when fenshu>60 and fenshu<80 then 'ºÏ¸ñ'
else '²î' end xx
from a

---

SQL code:

SELECT NAME,
FENSHU,
CASE
WHEN FENSHU > 80 THEN
'ÓÅÐã'
WHEN FENSHU BETWEEN 60 AND 80 THEN
'ºÏ¸ñ'
ELSE
'²î'
END XX
from A



ÄãÊÔÊÔ¡£

---

select name,fenshu,(case when fenshu>=80 then 'ÓÅÐã' when fenshu>=60 then 'ºÏ¸ñ' else '²îend) as xx
from a;

---

select name,fenshu,case when fenshu between 60 and 80 then "º