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
&
Ïà¹ØÎĵµ£º
Ó¦ÓÃϵͳ²»ÄÜÔËÐУ¬¸æ¾¯ÈÕÖ¾±¨¸æÁÙʱ±í¿Õ¼ä²»ÄÜÀ©Õ¹£¬¹À¼ÆÊÇÒµÎñsql´æÔÚ´óÁ¿ÅÅÐò£¬Ö»ÄÜÔö¼ÓÁÙʱ±í¿Õ¼ä»º½âÕâ¸öÎÊÌâ¡£
ÁíÍ⻹¿ÉÄÜÒªÇåÀíÁÙʱ¶ÎÖØÕûÁÙʱ±í¿Õ¼äÊͷſռ䣺
²é¿´Ò»ÏÂÈÏËÔÚÓÃÁÙʱ¶Î£º
SQL> SELECT /*+ rule */ se.username,se.sid,se.serial#,se.sql_address,se.machine,se.program,
su.tablespace,su.se ......
ÔÚJ2EEÓ¦ÓóÌÐò¿ª·¢ÖУ¬Ó¦ÓóÌÐòÓëÊý¾Ý¿âÁ¬½ÓµÄ½¨Á¢ÊÇÎÒÃǾ³£Óöµ½µÄÎÊÌâÖ®Ò»¡£ÔÚÕâÀïÎÒÖ÷Ҫ̸̸ÔÚ±¾µØÓ¦ÓóÌÐòÖÐͨ¹ýOCI·½Ê½¡¢thin·½Ê½ºÍJdbcOdbcÇÅ·½Ê½Á¬½ÓOracleÊý¾Ý¿â£¬ÔÚiPlanet Application Server 6.5ºÍSun ONE Application Server 7ÖжÔOracleÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖÃÒÔ¼°Ó¦ÓÃÖÐÈçºÎ´ÓÁ¬½Ó³ØÖлñµÃÁ¬½Ó¡£
Ò»¡¢±¾µØͨ¹ýJ ......
¹ÜÀí°²È«ÐÔ
1 Oracle±êʾ·û
¢Ù²»ÊDZ£Áô×Ö
¢Ú1~30¸ö×Ö·û
¢ÛÖ»ÄÜÊÇ×ÖĸºÍ#¡¢$¡¢_
¢Ü²»ÄÜ°üº¬µ¥ÒýºÅºÍË«ÒýºÅ
2 Óû§
ÔÚOracleÖУ¬Êý¾Ý¿âÓû§ºÍģʽÊÇ°²È«µÄ×î»ù±¾µ¥Ôª¡£
£¨1£©Óû§ºÍģʽ
Êý¾Ý¿âģʽ¶¨ÒåΪÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ£¬¶øģʽµÄÃû³Æ¾ÍÊÇÓµÓлò¿ØÖÆÕâЩÊý¾Ý¿â¶ÔÏ󼯺ϵÄÓû§Ãû³Æ¡£
£¨2£©½¨Á¢Ó ......
ÉÁ»Ø
1 ÌØÕ÷
ÉÁ»ØÊý¾Ý¿âÖ»ÊÇÂß¼Êý¾ÝÔâµ½ÆÆ»µÊ±µÄÊֶΡ£
ÉÁ»ØÊý¾Ý¿âÈÕÖ¾±ØÐëÔÚÊý¾Ý¿â»Ö¸´ÇøÖд´½¨¡£
ÉÁ»ØÈÕÖ¾²»ÐèÒª¹éµµ£¬²»ÄÜÓÃÓÚÎïÀí»Ö¸´¡£
Ö´ÐÐÉÁ»ØÊý¾Ý¿â²Ù×÷ʱ£¬±³¾°½ø³ÌRVWR¾ÍÆô¶¯ÁË¡£
2 ʹÓÃÉÁ»ØÊý¾Ý¿â
3ÖÖ¹¤¾ß£¬SQL*Plus£¬RMAN£¬OEM¡£
£¨1£©ÒªÇó
ΪÁËʹÓÃÉÁ»ØÊý¾Ý¿â£¬Êý¾Ý¿â±ØÐë´¦Óڹ鵵ÈÕ־ģʽ¡ ......
Ë÷Òý
1 ¸ÅÊö
Ë÷ÒýÊÇÒ»ÖÖÊ÷×´½á¹¹¡£
Ë÷Òý·ÖΪÂß¼Éè¼ÆºÍÎïÀíʵÏÖ¡£
Âß¼Éè¼Æ·ÖΪ£ºµ¥ÁÐË÷Òý¡¢¸´ºÏË÷Òý¡¢Î¨Ò»ÐÔË÷ÒýºÍ·ÇΨһÐÔË÷Òý¡¢»ùÓÚº¯ÊýµÄË÷Òý¡£
ÎïÀíʵÏÖ·ÖΪ£º·ÖÇøË÷Òý¡¢·Ç·ÖÇøË÷Òý¡¢BÊ÷Ë÷Òý¡¢ÕýÏòË÷Òý¡¢·´ÏòË÷Òý¡¢Î»Í¼Ë÷Òý¡£
ΩһË÷ÒýÊÇË÷ÒýÁÐÖµ²»ÄÜÖظ´µÄË÷Òý£¬·ÇΩһË÷Òý ......