mysql計算排名，獲取行號rowno
學生成績表數據
SELECT * FROM table_score ORDER BY score DESC;
獲取某個學生成績排名并計算該學生和上一名學生成績差，是并列排名
SELECT *,
(SELECT count(DISTINCT score) FROM table_score AS b WHERE a.scorea.score ORDER BY b.score LIMIT 1)-a.score AS subtract #獲取和上一名學生成績的差
FROM table_score AS a WHERE a.s_id = 13; #獲取學生周三的成績排名和與上一名的成績差
獲取所有學生成績排名-并列排名
SELECT *,
(SELECT count(DISTINCT score) FROM table_score AS b WHERE a.score
獲取所有學生成績排名，不是并列排名。計算行號進行排名
SELECT a.*,
(@rowNum:=@rowNum+1) AS rank #計算行號
FROM table_score AS a,
(SELECT (@rowNum :=0) ) b
ORDER BY a.score DESC;
文章版權歸作者所有，未經允許請勿轉載,若此文章存在違規行為，您可以聯系管理員刪除。
轉載請注明本文地址：http://specialneedsforspecialkids.com/yun/28598.html
