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

²é³öË­µÄ½±½ð×ܺÏÊÇ×î¸ßµÄ£¬SQLÓï¾ä

 Ô­ÎÄ´«ËÍÃÅ£ºhttp://topic.csdn.net/u/20091119/17/388cd1dd-4018-403f-a97f-0bc135895264.html?85256
Êý¾Ý¿âÀýÈç:
id      ÐÕ  Ãû  ½±  ½ð
1        ÕÅÈý    20Íò
2        ÀîËÄ    10Íò
3        ÍõÒ»    5Íò
4        ÍõÒ»    50Íò
5        ÀîËÄ    6Íò
ÎÒҪʵÏÖÏÂÃæµÄЧ¹û
id      ÐÕ  Ãû  ½±  ½ð
4        ÍõÒ»      55Íò
²é³öË­µÄ½±½ð×ܺÏÊÇ×î¸ßµÄ£¬SQLÓï¾äÓ¦¸ÃÔõôд
½¨±íÓï¾ä
-- Create table
create table TEST111
(
ID NUMBER,
NAME VARCHAR2(10),
T NUMBER
)
SQLÓï¾ä
SELECT A.ID, A.NAME, A.T, A.AA
from (SELECT T.ID, T.NAME, T.T, SUM(T.T) OVER(PARTITION BY T.NAME) AS AA
from TEST111 T
ORDER BY AA DESC

) A
WHERE ROWNUM = 1


Ïà¹ØÎĵµ£º

Access(jet sql)ÓëMS SQL Server(t

 ÍøÉÏËѼ¯£¬±¸ÓÃ
ϱíÁгöÁË ANSI SQL Êý¾ÝÀàÐͺ͵ÈЧµÄ Microsoft Jet Êý¾Ý¿âÒýÇæ SQLÊý¾ÝÀàÐÍ»¹ÓÐËüÃǵÄÓÐЧͬÒå×ÖÒÔ¼° µÈЧµÄ Microsoft SQL ServerÊý¾ÝÀàÐÍ¡£
ANSI SQL
Êý¾ÝÀàÐÍ
Microsoft Access
SQL Êý¾ÝÀàÐÍ
ͬÒå´Ê
Microsoft SQL
Server Êý¾ÝÀàÐÍ
BIT¡¢BIT VARYING
BINARY£¨²Î¼û×¢ÊÍ£©
VARBINARY¡¢ ......

ÊìÁ·OracleµÄSqlÓï¾ä±Ø×ö18µÀ

 Ê¹ÓÃscott/tigerÓû§ÏµÄemp±íºÍdept±íÍê³ÉÏÂÁÐÁ·Ï°£¬±íµÄ½á¹¹ËµÃ÷ÈçÏÂ
empÔ±¹¤±í(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
dept²¿Ãűí(deptno²¿ÃűàºÅ/dname²¿ÃÅÃû³Æ/locµØµã)
¹¤×Ê £½ н½ð £« Ó¶½ð
1£®ÁгöÖÁÉÙÓÐÒ»¸öÔ±¹¤µÄËùÓв¿ÃÅ
2£®Áгöн½ð±È& ......

ÎÞ·¨Á¬½Óа²×°µÄSQL Server 2005 Express

½ñÌìÔÚµçÄÔÉϰ²×°ÁËVisual Studio 2005£¬ÀïÃæ×Ô´øÁËÒ»¸öSQL Server 2005 Express¡£°²×°Íê³ÉÖ®ºó½øÈëVS£¬Ð½¨Ò»¸öÊý¾Ý¿âÏîÄ¿£¬Ôړн¨Êý¾Ý¿âÒýÓÔһ²½Óöµ½ÁËÆæ¹ÖµÄÎÊÌâ¡£
ÔÚ·þÎñÆ÷ÃûµÄÏÂÀ­ÁбíÀïÃæ£¬Í¨¹ýµã»÷“ˢД°´Å¥¿ÉÒÔÏÔʾµ±Ç°Í¨¹ýÍøÂç¿ÉÒÔÁ¬½Óµ½µÄÊý¾Ý¿âµÄÐÅÏ¢£¬ÆäÖÐÓÐÎÒµÄÖ÷»ú¡£È»¶ø£¬Ñ¡ÔñÁ ......

SQL×¢Èë©¶´È«½Ó´¥

 
µÚÒ»½Ú¡¢SQL×¢ÈëµÄÒ»°ã²½Öè
Ê×ÏÈ£¬Åжϻ·¾³£¬Ñ°ÕÒ×¢Èëµã£¬ÅжÏÊý¾Ý¿âÀàÐÍ£¬ÕâÔÚÈëÃÅÆªÒѾ­½²¹ýÁË¡£
Æä´Î£¬¸ù¾Ý×¢Èë²ÎÊýÀàÐÍ£¬ÔÚÄÔº£ÖÐÖØ¹¹SQLÓï¾äµÄԭò£¬°´²ÎÊýÀàÐÍÖ÷Òª·ÖΪÏÂÃæÈýÖÖ£º
(A) ID=49 ÕâÀà×¢ÈëµÄ²ÎÊýÊÇÊý×ÖÐÍ£¬SQLÓï¾äԭò´óÖÂÈçÏ£º
Select * from ±íÃû where ×Ö¶Î=49
×¢ÈëµÄ²ÎÊýΪID=49 And [²é ......

SQL×¢Èë©¶´È«½Ó´¥

 
¿´ÍêÈëÃÅÆªºÍ½ø½×ƪºó£¬ÉÔ¼ÓÁ·Ï°£¬ÆÆ½âÒ»°ãµÄÍøÕ¾ÊÇûÎÊÌâÁË¡£µ«Èç¹ûÅöµ½±íÃûÁÐÃû²Â²»µ½£¬»ò³ÌÐò×÷Õß¹ýÂËÁËÒ»Ð©ÌØÊâ×Ö·û£¬ÔõôÌá¸ß×¢ÈëµÄ³É¹¦ÂÊ£¿ÔõôÑùÌá¸ß²Â½âЧÂÊ£¿Çë´ó¼Ò½Ó×ÅÍùÏ¿´¸ß¼¶Æª¡£
µÚÒ»½Ú¡¢ÀûÓÃϵͳ±í×¢ÈëSQLServerÊý¾Ý¿â
SQLServerÊÇÒ»¸ö¹¦ÄÜÇ¿´óµÄÊý¾Ý¿âϵͳ£¬Óë²Ù×÷ϵͳҲÓнôÃܵÄÁªÏµ£¬Õâ¸ø¿ª·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ