mysql排名函数示例

## 重复的val排名不同，下一个数跳过

select t.uid, t.val, ROW_NUMBER() over (order by convert(val, signed) desc ) as calc_rank from b_user_process_progress t 
 where t.category ='ranking_bonus8' order by calc_rank asc  ;
 

## 重复的val排名相同，下一个数跳过
select t.uid, t.val, RANK() over (order by convert(val, signed) desc) as calc_rank from b_user_process_progress t 
 where t.category ='ranking_bonus8' order by calc_rank asc  ;
 

## 重复的val排名相同，下一个数不跳过

select t.uid, t.val, DENSE_RANK() over (order by convert(val, signed) desc) as calc_rank from b_user_process_progress t 
 where t.category ='ranking_bonus8' order by calc_rank asc  ;