题解 | #注册时间最早的三个人#
注册时间最早的三个人
https://www.nowcoder.com/practice/fbe36305c6dd4954a05cc2f2f12e4f4a
select
uid uid,
nick_name nick_name,
register_time
from
(
select
uid uid,
nick_name nick_name,
register_time,
row_number() over (
order by
register_time
) as rank_num
from
user_info
)t1
where
rank_num <= 3
