比如有两张表 用户表User {id name }
成绩表Score {id userid coursename courseScore}
现在怎么查找每个用户的最高成绩
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
不一定对你自己再改改。
用ID关联啊 desc oracle太久没用 了