Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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Óï¾äµÄд·¨£¨100·Ö£© - Java / Web ¿ª·¢

Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò
ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ.
sqltext="select top A * from log where id not in(select top ( ......

SQL²»Ã÷°× - MS-SQL Server / Ó¦ÓÃʵÀý

²éѯѧÉúƽ¾ù³É¼¨¼°ÆäÃû´Î 
  SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨) 
  from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨ 
  from SC&n ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ