with min_gpa AS (SELECT university,min(gpa) as gpa FROM user_profile GROUP BY university Order by university) -- 确定每个学校及最低点gpa值 select u.device_id,u.university,u.gpa from user_profile as u right join min_gpa on min_gpa.gpa=u.gpa and min_gpa.university=u.university