oracle中sql查询语句，求助

Question

比如有两张表 用户表User {id name }
成绩表Score {id userid coursename courseScore}
现在怎么查找每个用户的最高成绩

Answer 1

select distinct u.id,u.name,s.courseScore

from User as u
inner join

(

select max(courseScore) as courseScore , userid from Score
group by userid
)

as s
on u.id=s.userid

不一定对你自己再改改。