ORACLE常用SQL

分类: IT文章 • 2025-02-05 22:57:37

查询最大得分

select score, id
  from MY_TABLE
 where total_score = (select max(score) from MY_TABLE)

查询最大得分

select t1.score,t1.id from MY_TABLE t1
left join (select max(score) as score from MY_TABLE) t2
on t1.score = t2.score
where t2.score is not null