- 计算数据库某一字段的rank
e.g.为充值记录表进行排序,按照分数进行排序算出排名,当充值金额一样的时候,充值时间早的排名靠前
SET @rank=0; SELECT @rank:=@rank+1 AS rank, id, golds, created_at FROM deposit_records ORDER BY golds DESC, created_at ASC;
e.g.为充值记录表进行排序,按照分数进行排序算出排名,当充值金额一样的时候,充值时间早的排名靠前
SET @rank=0; SELECT @rank:=@rank+1 AS rank, id, golds, created_at FROM deposit_records ORDER BY golds DESC, created_at ASC;