按各科成绩进行排序

建表语句点击详见

– 按各科成绩进行排序

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