题解 | #找出每个学校GPA最低的同学#
找出每个学校GPA最低的同学
https://www.nowcoder.com/practice/90778f5ab7d64d35a40dc1095ff79065
select a.device_id,a.university,a.gpa from ( select a.device_id,a.university,gpa,min(gpa) over(partition by a.university) mingpa from user_profile a ) a where a.gpa = mingpa#sql##sql练习日常#
SQL练习 文章被收录于专栏
SQL练习
