题解 | 用户购买次数前三
用户购买次数前三
https://www.nowcoder.com/practice/e359c071d29c4fb7bac6d346f0cfe1d0
select uid,cnt
from(
select uid,count(uid) cnt,row_number()over(order by count(uid) desc,uid) rk from user_client_log
where step='order'
group by uid
) t
where rk<=3
不使用窗口函数的写法：(比上面简单)
select uid,count(uid) cnt from user_client_log where step='order' group by uid order by cnt desc,uid limit 3
投递喜马拉雅等公司6个岗位