题解 | #截取出年龄#
找出每个学校GPA最低的同学
http://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select t.device_id, t.university,round(t.gpa,4) from (select *,rank()over (partition by university order by gpa asc) as GPA_ranking from user_profile ) t where GPA_ranking = 1;
投递哔哩哔哩等公司9个岗位 >
京东HR面44人在聊