27,579
社区成员
发帖
与我相关
我的任务
分享
--SQL:每个月各个name的price和
SELECT
[month] = DATEPART(MONTH, date),
[name],
totalprice = SUM(price)
FROM table_name
GROUP BY DATEPART(MONTH, date), [name]
--SQL:所有name的price和
SELECT
[name],
totalprice = SUM(price)
FROM table_name
GROUP BY [name]
--每个月各个name的price和以及第个月所有name的price和
SELECT
[month] = DATEPART(MONTH, date),
[name],
totalprice = SUM(price),
allprice = SUM(price) OVER(PARTITION BY DATEPART(MONTH, date))
FROM table_name
GROUP BY DATEPART(MONTH, date), [name]
select name,sum(price) as sumprice from table where date between 起始日期 and 结束日期
group by name
select name,sum(price) as sumprice from table group by name