sql-server - 用函数插入另一个带有百分位数的表

Question

我正在使用 with 函数计算百分位数，因为我试图弄清楚如何将输出插入到另一个表中。到目前为止，我得到了：

    WITH PERCENTILES AS (SELECT TMC_code, EPOCH, percentile_CONT(.95)  
WITHIN GROUP (ORDER BY cast(travel_time_minutes as float)) OVER (PARTITION BY TMC_code) AS P95 FROM [dbo].[AR_2018_TRUCKS_1_3]
WHERE DATEPART(HOUR, EPOCH) between 16 and 17  AND (WKDAY != 'SAT' and WKDAY != 'SUN'))-- and datepart(month, date) = 12)  

insert testtmc
(TMC_code
,P95 
)
select TMC_code
    , P95
from percentiles 
GROUP BY TMC_code
    , P95 
ORDER BY TMC_CODE

标签： sql-server

Answer 1

您的插入语句在这里很古怪。您可以使用查询作为这样的插入语句的源。

insert testtmc
(
    TMC_code
    , P95 
)
select TMC_code
    , P95
from percentiles 
GROUP BY TMC_code
    , P95 
ORDER BY TMC_CODE