select * from
(
select cate1,cate2,title,count(uid),row_number() over(partition by cate1,cate2 order by count(uid) desc) as n
from t_ods_video_user_behavior
where idfa is not null and dt >= 20180621 and dt<= 20180628
group by cate1,cate2,title) a
where a.n <= 100
(
select cate1,cate2,title,count(uid),row_number() over(partition by cate1,cate2 order by count(uid) desc) as n
from t_ods_video_user_behavior
where idfa is not null and dt >= 20180621 and dt<= 20180628
group by cate1,cate2,title) a
where a.n <= 100