分数相同时显示相同排名

Yes, this behaviour is configurable via the score ranking strategy setting:

  • dense_rank (default) - Produces the tie behaviour shown in your screenshot
  • rank - Tied rows get the same rank, next rank is incremented by number of tied rows
  • row_number - Produces the tie behaviour shown in the original post
3 个赞