开窗函数row_number()

# 开窗函数求top10
select
    f_bank_name,
    f_bank_card_num
from (
    select
        f_bank_name,
        f_bank_card_num,
        count_num,
        row_number() over(partition by f_bank_name order by count_num desc) as rn
    from (
        select
            f_bank_name,
            f_bank_card_num,
            count(f_bank_card_num) as count_num
        from open.t_top_year_ext
        where f_bank_card_num <> '-'
        group by f_bank_name,f_bank_card_num
    ) t1
) t2 where rn <=10;