ÇóSQLÓï¾ä

´ó¼ÒºÃ£º
  Ò»Õűí´æ´¢µÄʵ¼ÊÄÚÈÝÈçÏ£º
  lc01  lc02  lc03
  p-m01  laty  1
  c-001  cathy  2
  ÇóÒ»ÌõSQLÓï¾ä
  µ±Îª lc03×Ö¶ÎΪ1 ʱÏÔʾΪÄÐ,µ±lc03×Ö¶ÎֵΪ2ʱ£¬ÏÔʾΪŮ
  ½á¹ûÈçÏ£º
  lc01  lc02  lc03
  p-m01  laty  ÄÐ
  c-001  cathy  Å®

---

SELECT LC01,LC02,CASE WHEN LC03=2 THNE 'Å®' ELSE 'ÄÐ' END AS LC03 from TB

---

select lco1,lco2,lco3=case  lc03 when 1 then 'ÄÐ' when 2 then 'Å®' end
from tb

---

ÒýÓÃ

SELECT LC01,LC02,CASE WHEN LC03=2 THNE 'Å®' ELSE 'ÄÐ' END AS LC03 from TB

up

---

SQL code:
select lc01,
lc02,
lc03=case when lc03=1 then 'ÄÐ' else 'Å®' end
from tb

---

SQL code:
select *,(case when lc03=1 then'ÄÐ' when lc03=2 then 'Å®'else null end) from tb

---

²»會ÓÐlc03=3Çé況°É£¿

---

ÒýÓÃ

²»會ÓÐlc03=3Çé況°É£¿

¹þ¹þ,±äÖÖÈË