row_number, dense_rank,rank method compare

来源:互联网 发布:标准体重 知乎 编辑:程序博客网 时间:2024/06/07 15:20

row_number: same column will be order by different number.

dense_rank: same column will be order by same number,and the after row will plus 1.

rank:same column will be order by same number,and ther after row will plus the sum same rows.

原创粉丝点击