gpt4 book ai didi

mysql order by 不是唯一的等级?

转载 作者:可可西里 更新时间:2023-11-01 08:54:26 26 4
gpt4 key购买 nike

<分区>

Possible Duplicate:
How do I Handle Ties When Ranking Results in MySQL?

我想按 Activepoints 对表 Status 进行排序,并将排名插入列 rank 中。它来了:

RANK   USERNAME   ACTIVEPOINTS

1 monkey100 92
2 fresnoJump 54
3 otherUser9 54

但它应该显示的不是唯一的排名

RANK   USERNAME   ACTIVEPOINTS

1 monkey100 92
2 fresnoJump 54
2 otherUser9 54

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com