SELECT * FROM (SELECT * FROM score WHERE c_id = '01' ORDER BY s_score DESC LIMIT 0,100 ) a
UNION ALL
SELECT * FROM (SELECT * FROM score WHERE c_id = '02' ORDER BY s_score DESC LIMIT 0,100) b
UNION ALL
SELECT * FROM (SELECT * FROM score WHERE c_id = '03' ORDER BY s_score DESC LIMIT 0,100) c;
SELECT * FROM score ORDER BY c_id,s_score DESC
-- 19、按各科成绩进行排序,并显示排名(实现不完全)
最新推荐文章于 2021-04-20 16:04:33 发布