摘要：-- 单科最高分是谁select * from topn where sco in (select max(sco) from topn group by clsno);-- 单科最高分是谁select * from topn awhere not exists (select * from top 阅读全文