Le Total des ventes par mois

Je pense que ce qui est commun, est-il?

Si vous avez une table avec SALES {Customer_ID, Price, SmallDateTime date}. Comment devez-vous déclarer toutes les ventes par mois?

SELECT Sum(Price) As Total Sales FROM SALES Group By What Having What

Grâce

OriginalL'auteur Costa | 2011-05-12

  1. 21
      SELECT YEAR(date) as SalesYear,
         MONTH(date) as SalesMonth,
         SUM(Price) AS TotalSales
    FROM Sales
GROUP BY YEAR(date), MONTH(date)
ORDER BY YEAR(date), MONTH(date)
    Vraiment merci pour ça 🙂

    OriginalL'auteur mellamokb

  2. 1
    SELECT CONVERT(CHAR(7), SmallDateTime, 120) as Year_Month,
       SUM(Price)
    FROM Sales
    GROUP BY CONVERT(CHAR(7), SmallDateTime, 120) 
    ORDER BY Year_Month

    OriginalL'auteur Joe Stefanelli

  3. 0

    Une autre solution consiste à calculer le premier jour du mois

    Select DateAdd(d,DateDiff(d,0,[Date])-DatePart(d,[Date])+1,0)
    , Sum( Price )
From Sales
Group By DateAdd(d,DateDiff(d,0,[Date])-DatePart(d,[Date])+1,0)

    OriginalL'auteur Thomas

  4. 0

    Essayer cette 

    SELECT A.CAL_YEAR AS YEAR  ,A.CAL_WEEK AS WEEK,SUM(B.SUM_OF_PROFIT) as profit FROM
CALANDER A,SALES_FACT B WHERE A.DATE_ID=B.DATE_ID
GROUP BY A.CAL_YEAR,A.CAL_WEEK;

    OriginalL'auteur SQL