此sql代码将使您的排名列为“排名”,并且可以与部分结果很好地配合,因此即使显示多页的第二页,也始终具有正确的排名:
SELECT (SELECT COUNT(*) + 1
FROM jss1_prelim ref
WHERE ref.score > main.score) as rank,
id, term, idnumber, subject, score, teacher
FROM jss1_prelim main
ORDER BY score DESC
php代码根据他们的得分(第1,第2,第3,第3,第5)给予排名
此sql代码将使您的排名列为“排名”,并且可以与部分结果很好地配合,因此即使显示多页的第二页,也始终具有正确的排名:
SELECT (SELECT COUNT(*) + 1
FROM jss1_prelim ref
WHERE ref.score > main.score) as rank,
id, term, idnumber, subject, score, teacher
FROM jss1_prelim main
ORDER BY score DESC