SQL data is divided into monthly statistics, the table only the daily data, now requires a year of the monthly statistics (a SQL )
SELECT
The field of that date),
Like sales or something)
From
Table
WHERE
Let's say you want to check it out. Monthly statistics of the year.
GROUP by
field of that date)
------------------------------------------------------------
1. Every year
Select year (ordertime),
SUM (total) Sales totals
From order Form
Group by year (Ordertime)
2. Monthly
Select year (ordertime),
Month (Ordertime),
SUM (total) Sales totals
From order Form
Group by year (Ordertime),
Month (ordertime
3. Daily
Select year (ordertime),
Month (Ordertime),
Day (Ordertime),
SUM (total) Sales totals
From order Form
Group by year (Ordertime),
Month (Ordertime),
Day (Ordertime)
In addition the daily can also be like this:
Select CONVERT (char (8), ordertime,112) DT,
SUM (total) Sales totals
From order Form
Group by CONVERT (char (8), ordertime,112) |
SQL query Monthly Sales Amount
