查看分位数

percentile_approx适用于非整型，percentile最终返回值为整型。详见——https://blog.csdn.net/Mr_Lian0614/article/details/131851806

select min(month_elecmean) as min,
	percentile_approx(month_elecmean,0.1) as quart1,
	percentile_approx(month_elecmean,0.2) as quart2,
	percentile_approx(month_elecmean,0.4) as quart3,
	percentile_approx(month_elecmean,0.6) as quart4,
	percentile_approx(month_elecmean,0.8) as quart5,
	percentile_approx(month_elecmean,0.9) as quart6,
	max(month_elecmean) as max from sr_mid_hlj_month;