1 -- 十分位，这个算法不是很准确 2 select  3 family_agreement_cnt -- 字段 4 ,dt -- 分区 5 ,rn -- 排序 6 ,cnt -- 总行数 7 ,percent2 -- 分位值 8  ,rk 9  ,row_num10 from (11 select12 t1.family_agreement_cnt -- 字段13 ,t1.dt -- 分区14 ,t1.rn -- 排序15 ,t1.cnt -- 总行数16 ,ceil(t1.rn / t1.cnt * 100) as percent2 -- 分位值17 ,row_number() over(partition by ceil(t1.rn / t1.cnt * 100) order by rn desc) as rk18 ,row_number() over(order by rn) as row_num19 from (20 select21  family_agreement_cnt22  ,dt23 ,row_number() over(partition by dt order by cast(family_agreement_cnt as double)) as rn24 ,count(1) over(partition by dt) as cnt25 from edw_dw_safe.out_elis_ai_high_quality_kpi_collection26 where dt=‘20180201‘27  ) t128 where t1.rn = 1 or t1.rn % cast(t1.cnt/10 as int) = 0 or t1.rn = t1.cnt29 order by t1.dt,t1.rn30 ) t231 where t2.rk = 132 ;33 34 35 -- 方差36 select 37 stddev(num) as std38 from (39 select 1 as num union all40 select 2 as num union all41 select 3 as num union all42 select 4 as num union all43 select 5 as num union all44 select 6 as num union all45 select 7 as num union all46 select 8 as num union all47 select 9 as num union all48 select 10 as num union all49 select 11 as num union all50 select 12 as num union all51 select 13 as num union all52 select 14 as num union all53 select 15 as num union all54 select 16 as num 55 ) t156 ;