4,816
社区成员
发帖
与我相关
我的任务
分享
select
region_code,
branch_company_code,
region_name,
branch_company_name,
catname,
aa_number_ty amt1,
rank() over(partition by catname ORDER BY aa_number_ty DESC) amt2,
aa_premium_ty amt3,
rank() over( partition by catname ORDER BY aa_premium_ty DESC) amt4,
Decode(aa_premium_ly,0,0,aa_premium_ty /aa_premium_ly) amt5,
rank() over( partition by catname ORDER BY Decode(aa_premium_ly,0,0,aa_premium_ty /aa_premium_ly) DESC) amt6,
aa_number_tm amt7,
rank() over( partition by catname ORDER BY aa_number_tm DESC) amt8,
aa_premium_tm amt9,
rank() over( partition by catname ORDER BY aa_premium_tm DESC) amt10,
Decode(aa_premium_smly,0,0, aa_premium_tm /aa_premium_smly) amt11,
rank() over( partition by catname ORDER BY Decode(aa_premium_smly,0,0, aa_premium_tm /aa_premium_smly) DESC) amt12
from
mytable
where
R_DISPLAY=3
and
aa_date='20090719'