select
gpa
from
(
select device_id,
gpa,
dense_rank() over(order by gpa) as 排名
from
user_profile
where university = '复旦大学') as t
where 排名 = 1
gpa
from
(
select device_id,
gpa,
dense_rank() over(order by gpa) as 排名
from
user_profile
where university = '复旦大学') as t
where 排名 = 1