WITH RankedStudents AS ( SELECT id, name, score, RANK() OVER (ORDER BY score DESC) AS student_rank FROM scores ) SELECT name FROM RankedStudents WHERE student_rank = 2;
点赞 评论

相关推荐

牛客网
牛客企业服务