从题解中得知,还有下面着一种查询方式: select gpa from ( select gpa, row_number() over ( partition by university order by gpa desc ) as ranking from user_profile where...