上个月在sql中滚动数据的12个月-Java 学习之路

我想找到供应商组的总成本，在12个月滚动平均值上计算 .

SELECT 
        sum(AEBill.[TotalCost])
        ,AEEnc.ProviderID
                ,AEEnc.Date
        INTO #TotalCostAccuteCareAE
        FROM EncDetail AEEnc
        INNER JOIN [EncBilling] as AEBill
        ON  AEBill.[SK_EncID] = AEEnc.[SK_EncID]    
            AND AEBill.ProviderID = AEEnc.ProviderID
                WHERE AEEnc.Date <= reportDate
        GROUP BY AEBill.ProviderID

此查询仅选择小于或等于报告日期的所有记录的总和 . 但我希望从给定月份开始的12个月的平均成本 .

1 回答

看看这个问题SQL Server: Get data for only the past year

SELECT 
    AVG(AEBill.[TotalCost])
    ,AEEnc.ProviderID
            ,AEEnc.Date
    INTO #TotalCostAccuteCareAE
    FROM EncDetail AEEnc
    INNER JOIN [EncBilling] as AEBill
    ON  AEBill.[SK_EncID] = AEEnc.[SK_EncID]    
        AND AEBill.ProviderID = AEEnc.ProviderID
            WHERE AEEnc.Date <= DATEADD(year,-1,GETDATE())
    GROUP BY AEBill.ProviderID

回复于 2024-04-20T15:30:12+08:00

上个月在sql中滚动数据的12个月

1 回答

相关问题