¿ÉÒÔÕâÑùдSQLÂ𣿠- .NET¼¼Êõ / ASP.NET

select id,pid,d_name,case when del_sign=0 then '»î¶¯' else 'ÒÑɾ³ý' as del_sign from dept_name order by pid

ÎÒÏë°ó¶¨DataGrid£¬ÅжÏÊÇ·ñɾ³ýÀ¸ÏëÏÔʾ ¡°»î¶¯¡±»ò¡°ÒÑɾ³ý¡±£¨¼´¸ù¾Ý0£¬1À´¾ö¶¨£©

ÌáʾÓï·¨Óдí....

---

ÉÙÁËÒ»¸öEND£¬
case when end

---

¶ÔÍ·¡£¶¥Â¥ÉϵÄͼ

---

caseȱÉÙ end

---

ßÀ£¬ÉÙ¸öend¡£¡£¡£´óÒâÁË

Áí£ºÎÒÏë¸ù¾ÝpidÏÔʾ³öd_name£¬ÒªÔõôдÄØ£¿ÔÙÌײãselect?

---

ÒýÓÃ

SQL code

select id,pid,d_name,case del_sign when 0 then '»î¶¯' else 'ÒÑɾ³ý' end as del_sign from dept_name order by pid

up

---

Îҵıí½á¹¹ÊÇÎÞÏÞ¼¶·ÖÀàµÄ£¬ÎÒÏëÔÚÏÔʾijһid¶ÔÓ¦µÄÖÐÎÄÃû×Ö(d_name)µÄʱºòÒ²ÏÔʾÆ丸id(¼´pid)¶ÔÓ¦µÄÖÐÎÄÃû×Ö(d_name)

---

ÒýÓÃ

ßÀ£¬ÉÙ¸öend¡£¡£¡£´óÒâÁË

Áí£ºÎÒÏë¸ù¾ÝpidÏÔʾ³öd_name£¬ÒªÔõôдÄØ£¿ÔÙÌײãselect?

ʾÀý:
SELECT ProductNumber, Name, 'Price Range' = 
  CASE 
  WHEN ListPrice = 0 THEN 'Mfg item - not for resale'
  WHEN ListPrice < 50 THEN 'Under $50'
  WHEN ListPrice >= 50 and ListPrice < 250 THEN 'Under $250'
  WHEN ListPrice >= 250 and ListPrice < 1000 THEN 'Under $1000'
  ELSE 'Over $1000'
  END
from Production.Product
ORDER BY ProductNumber ;

---

SQL code

---

Code highlighting