WITH RankedStudents AS ( SELECT student_id, name, score, DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank FROM students WHERE gender = '男' ) SELECT student_id, name, score, dense_rank FROM RankedStudents WHERE dense_rank <= 10;
点赞 评论

相关推荐

对空六翼:你真幸运,碰见这么好的人,不像我,秋招的时候被室友骗进cx了
实习好累,可以辞职全力准...
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务