摘要：select * from sc where score=(select max(score) from sc where score<>(select max(score) from sc))不灵活 select *from (select row_number() over (order by score desc) as idx, * from sc ) as tmptablew... 阅读全文