[摘要]+-------------+-------+--3.rank式的排序SET @row=0,@rank=0,@prev_score=NULL;SELECT @row:=@row+1 AS ROW,@...
+-------------+-------+
--3.rank式的排序
SET @row=0,@rank=0,@prev_score=NULL;
SELECT @row:=@row+1 AS ROW,
@rank:=IF(@prev_score=score,@rank,@row) AS rank,
@prev_score:=score AS score
FROM tb
ORDER BY score DESC;
+------+------+-------+
关键词：MySQL对于运用变量完成各种排序的示例代码区分