好像有点zz了这个解法orz select r.id,r.job,r.score,r.t_rank from (select id, job, score, row_number() over(partition by job order by score desc) t_rank from grade) r where (r.job,r.t_rank) in (select job, case when count(id) & 1 = 1 then...
