oracle中分析函数 (over rank dense_rank row_number)

http://www.blogjava.net/pengpenglin/archive/2008/06/25/210536.html   OVER

http://blog.sina.com.cn/s/blog_4cef5c7b0100tsph.html      Rank  Dense_rank row_number

select a ,row_number() over(order by a) as line;

按照a对记录进行排名，返回line（排名值)

 

row_number

select a,row_number() over(order by a) as line;

     a                     lline

     45                      1

    46                       2

    46                       3

    47                       4

 

Rank

select a,rank()over(order by a) as line;

   a                     lline

     45                      1

    46                       2

    46                       2

    47                       4

 

Dense_rank

select a,Dense_rank()over(order by a) as line;

     a                     lline

     45                      1

    46                       2

    46                       2

    47                       3