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,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID 1,Name1....test1,1,99 1,Name1....test1,3,99 1,Name2....test2,1,101 1,Name2....test2,3,101 1,Name3....test3,2,101 1,Name1....test1,4,101 ÏëÒªµÄ½á¹ûÊÇ: 1,Na ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ. sqltext="select top A * from log where id not in(select top ( ......
²éѯѧÉúƽ¾ù³É¼¨¼°ÆäÃû´Î SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨) from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨ from SC&n ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......