题解 | 用户购买次数前三
用户购买次数前三
https://www.nowcoder.com/practice/e359c071d29c4fb7bac6d346f0cfe1d0
select uid, cnt from( select uid, count(distinct trace_id) as cnt, row_number()over(order by count(distinct trace_id) desc,uid) as pdiff from user_client_log where step="order" group by uid ) as t where t.pdiff<=3
查看25道真题和解析