Я хочу рассчитать значение Percentile в sql server 2008. Этот скрипт работает в sqlserver 2012, но в 2008. Есть ли эквивалент centile_cont в sqlserver 2008?
select DISTINCT col_1,col_2
,PERCENTILE_CONT(0.25) WITHIN GROUP (ORDER BY col_3) OVER (PARTITION BY col_1,col_2) AS P25
,PERCENTILE_CONT(0.50) WITHIN GROUP (ORDER BY col_3) OVER (PARTITION BY col_1,col_2) AS P50
,PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY col_3) OVER (PARTITION BY col_1,col_2) AS P75
from table
