SQLÖ® case when then
ÊÓͼ²éѯÖÐÔõÑù½«Ô¶¨ÓÚÈçÐÔ±ðsex ÕâÑùµÄ×ֶΣ¬×Ö¶ÎֵΪ0£¬1ÕâÑùµÄintÀàÐÍÖµ£¬²éѯʱֱ½Ó·µ»Øvarchar
Ð͵Ä×Ö·û‘ÄÐ’£¬‘Å®’ÒÔ±ãÓÚÎÒÃǶÁÈ¡ÄØ£¿
ÓÐÈË»áÏëµ½if …else…ÕâÑùµÄÓï¾ä£¬¿ÉÊÇÔõô¼Ó£¬¶¼²»ÖªµÀ¼ÓÄÄÀÒòΪ×ÜÊÇ»á³ö´í¡£ÆäʵsqlÖÐÓÐÒ»¸öº¯ÊýÄܽâ¾öÕâÑùµÄ²éѯ¶ÁÈ¡ÖµµÄÎÊÌâ¡£ÄǾÍÊÇÏÂ
ÃæÒª½éÉÜµÄ Case º¯ÊýÁË¡£
Case ÊǼÆËãÌõ¼þÁÐ±í²¢·µ»Ø¶à¸ö¿ÉÄܵĽá¹û±í´ïʽ֮һ¡£
Case ÓÐÁ½ÖÖ¸ñʽ£º
¼òµ¥ Case º¯Êý½«Ä³¸ö±í´ïʽÓëÒ»×é¼òµ¥±í´ïʽ½øÐбȽÏÒÔÈ·¶¨½á¹û¡£
Case ËÑË÷º¯Êý¼ÆËãÒ»×é²¼¶û±í´ïʽÒÔÈ·
¶¨½á¹û¡£
Á½ÖÖ¸ñʽ¾ùÖ§³Ö¿ÉÑ¡µÄ ELSE ²ÎÊý¡£
Óï·¨
1. CASE
input_expression
WHEN
when_expression
THEN
result_expression
[
...n
] [ELSE else_result_expression
] END
2. CASE
WHEN
Boolean_expression
THEN
result_expression
[ ...n
] [
ELSE else_result_expression
] END
Àý×Ó
1.Ó﷨ʵÀý£º
SELECT Name,Age,CASE Gender WHEN 1 THEN 'Å®' WHEN 2 THEN 'ÄÐ' ELSE
'δÌî' END AS Genders from dbo.Contacter_Detail
2. Ó﷨ʵÀý£º
SELECT Name,Age,CASE WHEN Gender = 1 THEN 'Å®' WHEN .Gender = 2
THEN 'ÄÐ' ELSE 'δÌî' END AS Genders,
from dbo.Contacter_Detail
Á½Õß·µ»ØµÄ½á¹ûÊÇÒ»Ñù¡£ºÜ¼òµ¥£¬Ò»¶¨¼ÇסºóÃæ±í´ïʽºóÃæÓиöEND½áβÄØ£¡
Ïà¹ØÎĵµ£º
À´×Ôhttp://hi.baidu.com/zcy60156/blog/item/42b6c5802a33859af603a685.html
ÍƼöÊÇÓô洢¹ý³Ì¼ÓÊÂÎñʵÏÖ.»òÖ±½ÓÔÚaspÀïд¼ÓÉÏÊÂÎñ¾Í¿ÉÒÔͬʱµÄ²åÈëÁË.Èç¹ûÖмä³ö´íµÄ»°»¹Äܻعö,¿É±£³ÖÊý¾ÝµÄÒ»ÖÂÐÔ.È¥baiduÉÏËÑË÷Ò»ÏÂÊÂÎñµÈµÄÏà¹Ø×ÊÁϺܶàµÄ.
ÔÚ¿ª·¢WebÓ¦ÓÃʱ£¬ÎÞÒ»ÀýÍâµØÐèÒª·ÃÎÊÊý¾Ý¿â£¬ÒÔÍê³É¶ÔÊý¾ÝµÄ²éѯ¡¢²åÈë¡¢¸ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
1¡¢SQLÊÇÒ»ÖÖ˵Ã÷ÐÔÓïÑÔ£¬²»Êǹý³Ì»¯ÓïÑÔ¡£ÀàËÆ“¼ìË÷->¼ì²é->²åÈë->¸üДµÄ¹ý³Ì»¯²½ÖèµÄ˳ÐòÊÇûÓÐÒâÒåµÄ¡£Ó¦¸ÃÒÔÐм¯µÄ·½Ê½Ë¼¿¼£¬ÒÔÃèÊöÒ»¸öÂß¼µÄÓïÑÔ·½Ê½Ë¼¿¼¡£
2¡¢ÔÚÉè¼ÆÊý¾Ý¿â±í×Ö¶Îʱ£¬Ò»¸öÐÐÃèÊöÓ¦¸Ã°üº¬Ò»¸öÊÂʵ£¬¶øÇÒÊÇÈ«²¿ÊÂʵ¡£ÀýÈ翼ÇÚ¿¨µÄÉè¼Æ£¬
²»ÒªÉè¼ÆΪ£º[ userId, puchTime, even ......
MFCÖÐÓÃado·ÃÎÊSQL Server 2005Êý¾Ý¿â
½ñÌìÀÏ´ó½»´úÏîÄ¿£¬ÐèÒªMFC·ÃÎÊÁíһ̨»úÆ÷É쵀 SQL Server 2005Êý¾Ý¿â¡£MFCÎÒ²»Ê죬SQLÒ²´ÓûÓùý¡£ÔÚÍøÉϲéÁ˲»ÉÙ×ÊÁÏ£¬Ã¦ÁËÒ»ÕóÖÕÓÚ¸ãͨÁË¡£Óë¸÷λÅóÓÑ·ÖÏíһϣ¬¸ßÊÖÃǾͲ»Óÿ´ÁË£¬ÕâÊÇд¸øÏñÎÒÒ»Ñù³õѧÕߵġ£
Ò»¡¢°²×°SQL SERVER 2005£¬ÔÚ±¾»ú½¨Á¢·þÎñÆ÷ĬÈÏ°²×°¼´¿É£¬Ò²¿ÉÒÔ×Ô¼ ......
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......