运营想要找到每个学校gpa最低的同学来做调研,请你取出每个学校的最低gpa
解析:需要子循环!!
select device_id,university,gpa from user_profile
where (university,gpa) in
(select university,min(gpa) from user_profile group by university)
order by university
运营想要找到每个学校gpa最低的同学来做调研,请你取出每个学校的最低gpa
解析:需要子循环!!
select device_id,university,gpa from user_profile
where (university,gpa) in
(select university,min(gpa) from user_profile group by university)
order by university