SQL ²éѯÏÔʾ

ÎÒÓÃ
Àý×Ó £ºSelect State from product
²éѯµÄ½á¹ûÏÔʾ ÊÇ  0£¬1£¬2 ÕâÑùµÄÊý×Ö
0´ú±íÔÚ¿â £¬1´ú±í³ö¿â£¬2´ú±í·µ³§¡£
ÔÚ²éѯʱ ÈçºÎ¸ù¾ÝÏàÓ¦µÄ×Ö·û ÏÔʾ¶ÔÓ¦µÄºº×Ö״̬
ÓÃSQLÓï¾ä ÈçºÎʵÏÖ
лл´ó¼Ò 

---

SQL code:


SELECT (CASE STATE
WHEN 0 THEN 'ÔÚ¿â'
WHEN 1 THEN '³ö¿â'
WHEN 2 THEN '·µ³§'
END)
from PRODUCT

---

SQL code:

select
case State when 0 then 'ÔÚ¿â' when 1 then '³ö¿â' else '·µ³§' end as State
from product

---

SQL code:

»òÕß

SELECT (CASE
WHEN STATE=0 THEN 'ÔÚ¿â'
WHEN STATE=1 THEN '³ö¿â'
WHEN STATE=2 THEN '·µ³§'
END)
from PRODUCT

---

SQL code:
select case State when 0 then 'ÔÚ¿â'
when 1 then '³ö¿â'
when 2 then '·µ³§'
end as State
from product

---

SQL code:
sel