摘要: examination表,字段为id, name, course, score,查询每门课的最高分和人数 select course,score,count(*)count from (select * from examinatioin a where score=(select max(scor 阅读全文