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

OracleÅÅÐòÒÔ¼°ÐòºÅµÄÊä³ö

   ÔÚÒ»°ãSelectÓï¾äÖÐÎÒÃÇͨ¹ýOrder by ...Asc/DescÀ´½øÐÐÅÅÐò¡£µ«ÊÇÕâÖÖÅÅÐò·½Ê½ÔÚÊä³öʱ£¬²»°üº¬ÅÅÐòºóµÄÐòºÅÐÅÏ¢¡£
   ÏÖÔÚ½éÉÜÒ»ÏÂOracleÖпÉÒÔÓÃÓÚÅÅÐòÊä³öµÄ·½·¨¡£
   1. RANK ( ) OVER ( [query_partition_clause] order_by_clause )
   RANK ( ) OVER ( [query_partition_clause] order_by_clause )ÖÐ[query_partition_clause]±íʾOracleÖзÖ×é·½·¨£¬Í¨³£Óï¾ä¸ñʽΪ£ºpartition by ÁÐÃû1[,ÁÐÃû2...] 
   order_by_clause ±íʾÅÅÐòµÄÒÀ¾Ý£¬Í¨³£Óï¾ä¸ñʽΪOrder by ÁÐÃû1[,ÁÐÃû2...]¡£ÕâÓëSelectÓï¾äÖÐOrder by Óï¾äÏàͬ¡£Ò»Ñù¿ÉÒÔÔÚÁÐÃûºóÌí¼ÓAsc£¨Ä¬ÈÏ£©»òDesc½øÐÐÉýÐòºÍ½µÐòµÄÑ¡Ôñ¡£
   ²ÉÓÃRANK ( ) OVER ( [query_partition_clause] order_by_clause )ºóÐòºÅµÄ¸ñʽÈçÏÂÀý:1,2,2,4,5,5,5,8,9,10...
   RANK ( ) OVER ( [query_partition_clause] order_by_clause )¶ÔÓÚ²éѯ³öÓï¾äÒ²»á½øÐÐ×Ô¶¯ÅÅÐò¡£
  
   Àý£º±íScoreTbÊý¾ÝÈçÏÂ
   GroupID                   PLAYNAME                  SCORE
    ----------  ------------------ -------------------- ----------
         01                           a1                          100
         01                           a2                          100
     &


Ïà¹ØÎĵµ£º

oracleÊý¾Ý¿âͨ¹ýÃüÁîµÇ¼£¬Ö´ÐÐSQLÓï¾ä

¡¡¡¡¡¡
        һֱûÓÐÍæ¹ýͨ¹ýÃüÁîÔÚDOSÏÂÖ´ÐÐoracleÊý¾Ý¿â,ËäÈ»¸ã¿ª·¢2ÄêÁË£¬»òÐíÕâÆªÎÄÕÂдµÃ±È½Ï·ôdz£®µ«»òÐí¶ÔÄÄЩ¸Õ¸ÕѧORACLEµÄÅóÓÑ»¹ÊÇÓÐÒ»¶¨°ïÖúµÄ£®
¡¡¡¡¡¡Í¨¹ýÃüÁîÄܹ»ºÜºÃµÄÖ´ÐдóÅúÁ¿Êý¾Ý½Å±¾£§½Å±¾£®sql£§£®±ÜÃâͨ¹ýPLSQL DeveloperÖ´ÐÐÅúÁ¿Êý¾ÝÔì³ÉµÄËÀ»úÇé¿ö£®
¶þ ......

ÔÚOracleÊý¾Ý¿âʵÏÖ×Ô¶¯¶Ï¿ªºóÔÙÁ¬½Ó

ÔÚʵ¼ÊµÄÊý¾Ý¿âÓ¦ÓÃÖУ¬ÎÒÃǾ­³£Óöµ½ÕâÑùÒ»¸öÎÊÌ⣬Á¬½Óµ½OracleÊý¾Ý¿âµÄÓû§ÔÚ×÷ÁËÒ»´Î²Ù×÷ºó£¬ÔÙҲûÓкóÐø²Ù×÷£¬µ«È´³¤Ê±¼äûÓкÍÊý¾Ý¿â¶Ï¿ªÁ¬½Ó¡£¶ÔÓÚÒ»¸öСÐ͵ÄÓ¦ÓÃϵͳÀ´½²£¬±¾ÉíµÄÁ¬½ÓÊýÄ¿¾ÍÓÐÏÞ£¬ÕâºÃÏñûÓÐʲôÑÏÖØµÄºó¹û£¬µ«Èç¹û¶ÔÓÚÒ»¸ö´óÐ͵ÄÊý¾Ý¿âÓ¦Óá£Èç˰Îñ¡¢¹¤É̵ȣ¬Èç¹ûÊý¾Ý¿âµÄÁ¬½ÓÊýÄ¿ºÜ¶à£¬¶ÔÓÚÊý¾Ý¿â ......

oracle²¹¶¡ÏÂÔØ

oracle²¹¶¡ÏÂÔØ
¹Ø¼ü×Ö: oracle
9.2.0.4  = 3095277
9.2.0.5  = 3501955
9.2.0.6  = 3948480
9.2.0.7  = 4163445
9.2.0.8  = 4547809£¨9i×îÖÕ£©
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189 ......

Oracle×Ö·û¼¯ÎÊÌâ×ܽá

¾­³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝÇ¨ÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂÇ¨ÒÆÊ§°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ÉÂÒÂë¡£ÏÖÔÚÎÒ½«oracle×Ö·û¼¯Ïà¹ØµÄһЩ֪ʶ×ö¸ö¼òµ¥×ܽᣬϣÍû¶Ô´ó¼Ò½ñºóµÄ¹¤×÷ÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ ......

ÓëoracleÊý¾Ý¿âÁ¬½ÓÎÊÌâ

       Èç¹û²»ÊÇÒòΪÕâ´Î»»hisµÄ·þÎñÆ÷£¬¹À¼ÆÎÒÒ»Ö±Ò²²»»áÓöµ½Õâ¸öÎÊÌ⣬һֱ¾õµÃoracleºÜ¸ßÉ¶ÔËüҲûÓÐÑо¿£¬¿ÉÕâ´Î»»·þÎñÆ÷£¬Æ«Æ«ÈÃÎÒÓöµ½ÁËÒ»¸öÎÊÌ⣬ÕÛÄ¥ÁËÕûÕûÁ½Ì죬ÖÕÓÚÔÚ×òÌì½â¾öµôÁË£¬¼Ç¼ÏÂÀ´£¬ÒÔ±¸ÒÔºóËùÓá£
    ÖÜÎåÍíÉÏ»»ÁË·þÎñÆ÷£¬ÖÜÒ»ÔçÉÏ·¢ÏÖ³¬ÉùµÄ¹¤×÷Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ