mysql计算排名
-- 假设有一张学生成绩表，包含学生ID，科目编号和成绩三个字段，表名为`score` SELECT s1.student_id, s1.subject_id, s1.score, COUNT(DISTINCT s2.score) + 1 AS rank FROM score s1 INNER JOIN score s2 ON s1.score
-- 假设有一张学生成绩表，包含学生ID，科目编号和成绩三个字段，表名为`score` SELECT s1.student_id, s1.subject_id, s1.score, COUNT(DISTINCT s2.score) + 1 AS rank FROM score s1 INNER JOIN score s2 ON s1.score
