每月总销售额
it1352
帮助6人
问题说明
如果您有一个带有 SALES {Customer_ID, Price, SmallDateTime date} 的表格.您如何报告每月的所有销售额?
If you have a table with SALES {Customer_ID, Price, SmallDateTime date}. How do you report all sales per month?
SELECT Sum(Price) As Total Sales FROM SALES Group By What Having What
正确答案
#1
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)
这篇好文章是转载于：学新通技术网
