sqlÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£© emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿ b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿ c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿ d 4 ÆäËû 1500 °ì¹«ÊÒ Ð½×ÊÔö³¤¸ù¾ÝְλÀ´Ôö£¨¹¤³Ìʦн×ÊÔö³¤ÔÀ´µÄ1.2±¶£¬ÆÕͨԱ¹¤Ôö³¤ÎªÔÀ´µÄ1.1±¶£¬ÆäËûµÄÔö³¤ÎªÔÀ´µÄ1.05±¶£© ÎÒÒª²é³ö¼ÓнǰºÍ¼ÓнºóµÄÈ˵ÄÐÅÏ¢£¨ÓÃsqlÓï¾ä±íʾ³öÀ´£¬ÎÒ¸ÃÔõôдÄØ£¬Çë½Ì¸ßÊÖÁË£¬Ð»Ð»£¡£©
SQL code: select ÐÕÃû, ÈËÔ±±àºÅ, ְλ, н×Ê=(case when ְλ='¹¤³Ìʦ' then н×Ê*1.2 when ְλ='ÆÕͨԱ¹¤' then н×Ê*1.05 else н×Ê end), н×Ê as [н×Ê(µ÷ÕûÇ°)] from emp SQL code: select t.* , case ְλ when '¹¤³Ìʦ' then н×Ê * 1.2 when 'ÆÕͨԱ¹¤' н×Ê * 1.1 else н×Ê * 1.05 end ¼Óнºó from emp t Ç¿°¡£¬¶¼ÄÜ¿´¶®ÒýÓà SQL code select ÐÕÃû, ÈËÔ±±àºÅ, ְλ, н×Ê=(case when ְλ='¹¤³Ìʦ' then н×Ê*1.2 when ְλ='ÆÕͨԱ¹¤' then н×Ê*1.05 else н×Ê end), н×Ê as [н×Ê(µ÷ÕûÇ°)] from emp SQL code Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighl
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ XML code: <upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......
ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ Óï¾äÈçÏ£º SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......