web | Java

写出SQL 求每个店铺访问次数top3的访客信息,输出店铺名称、访客id、访问次数

千锋教育

select t2.shop, t2.user_id, t2.user_count from ( select shop, user_id, user_count, rank() over(partition by shop order by user_count) 


`rank` from ( select shop,user_id,count(user_id) 


`user_count` from Visit group by shop,user_id ) t1 ) t2 where t2.rank <= 3;