题解 | #注册时间最早的三个人#

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