sqlserverµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

ÓÐÒ»ÕÅ±í£¬ÀïÃæÓÐ3¸ö×ֶΣºÓïÎÄ£¬Êýѧ£¬Ó¢Óï¡£ÆäÖÐÓÐ3Ìõ¼Ç¼·Ö±ð±íʾÓïÎÄ70·Ö£¬Êýѧ80·Ö£¬Ó¢Óï58·Ö£¬ÇëÓÃÒ»ÌõsqlÓï¾ä²éѯ³öÕâÈýÌõ¼Ç¼²¢°´ÒÔÏÂÌõ¼þÏÔʾ³öÀ´£¨²¢Ð´³öÄúµÄ˼·£©£º
´óÓÚ»òµÈÓÚ80±íʾÓÅÐ㣬´óÓÚ»òµÈÓÚ60±íʾ¼°¸ñ£¬Ð¡ÓÚ60·Ö±íʾ²»¼°¸ñ¡£
ÏÔʾ¸ñʽ£º
ÓïÎÄÊýѧӢÓï
¼°¸ñÓÅÐã²»¼°¸ñ

---

»¹ÊÇ´æ´¢¹ý³Ì°É

---

ÓÃcase then

---

case when

---

SQL code:

select ×Ö¶ÎÃû=

case when ³É¼¨ > 60 then '¼°¸ñ'

case when ³É¼¨ > 80 then 'ÓÅÐã'

case when ³É¼¨ < 60 then '²»¼°¸ñ'

end from ±íÃû

---

²»ÖªµÀ¶Ô²»¶Ô ÎÒÒ²²ËÄñÂÒÏëµÄ

---

ÒýÓÃ

case when

·Ç³£ÕýÈ·

---

´ó¼Ò¶¼ËµÍêÁË£¬Ã»Ê²Ã´ºÃ˵µÄÁË£¬Â·¹ý

---

SQL code:

--Äã˵µÄÊÇ3¸ö×Ö¶ÎÊÇÓïÎÄ£¬Êýѧ£¬Ó¢Óï
--ÄDZí¾ÍÓ¦¸ÃÊÇ£º
-- YuWen YinYu ShuXue
-- 70 58 80
-- .. .. ..
-- .. .. ..

select
case
when YuWen <60 then '²»¼°¸ñ'
when YuWen>=60 and YuWen<=70 then '¼°¸ñ'
when YuWen>=80 then 'ÓÅÐã'
end 'YuWen',
case
when YinYu <60 then '²»¼°¸ñ'
when YinYu>=60 and YinYu<=70 then '¼°¸ñ'
when YinYu>=80 then 'ÓÅÐã'
end 'YinYu',case
when ShuXue <60 then '²»¼°¸ñ'
when ShuXue>=60 and ShuXue<=70 then '¼°¸ñ'