oracle 分组查询,随机N条数据

按城市，随机取N条 用户信息

select 
    UserName,
    Phone,
    Sex,
    City 
from (
        select 
            -- UserName,
            -- Phone,
            -- Sex,
            -- City,
            UserInfo.*,
            row_number() over(partition by City order by dbms_random.random) rn
         from 
            UserInfo  
       )
where rn <= N