ROW_NUMBER()
连续排序,不存在并列排序的情况
RANK()
不连续排序,存在并列排序的情况,
DENSE_RANK()
连续排序,存在并列排序的情况,
SELECT class,
val,
ROW_NUMBER() OVER (PARTITION BY class ORDER BY val) AS row_num,
RANK() OVER (PARTITION BY class ORDER BY val) AS rank,
DENSE_RANK() OVER (PARTITION BY class ORDER BY val) AS dense_rank
FROM T;