注意下单是order
select distinct uid,cnt
from(
select uid,count(pay_method) cnt,rank()over(order by count(pay_method) desc) ranking
from user_client_log
where step='order'
group by uid
) t
where ranking<=3
order by cnt desc,uid
limit 3