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