Rank () Over,dense_rank (), the difference between row_number ()

1. Rank () Over is the function of finding a rank after the specified condition is detected, but there is a feature. If it is the student rankings, then practical this function, the results of the same two are tied, for example 1 2 2 4.

2. 2

   Dense_rank () The Role and rank () very much like, the only difference is that brought life student's results tied up, the next classmate does not empty the rank of the side, for example, 1 2 2 3.

3. 3

   Row_number () is not the same, and the difference between it and the above is very obvious, this function does not need to consider whether to tie, even if the value of the query based on the same values will continue to rank, such as

   Reference from: http://jingyan.baidu.com/article/597035521ff2ec8fc107404b.html

Rank () Over,dense_rank (), the difference between row_number ()