sqlserver 查询出每个月销售的最好的产品_如何编写一个sql查询过去一个月内最好的10个产品-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_34417247/article/details/136698199

文章详细描述了如何使用SQL创建产品表，插入随机数据，并执行一个聚合查询来获取每个月每个产品的总金额。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

表结构

create table prodects
(
id uniqueidentifier,
pname nvarchar(50),
ptype int,
money int,
months int,
datatime date
)
drop table prodects
truncate table prodects
insert into prodects values(NEWID(),'书本',1,RAND()*1000,1,'2024-01-01')
insert into prodects values(NEWID(),'笔',2,RAND()*1000,1,'2024-01-02')
insert into prodects values(NEWID(),'手机',3,RAND()*1000,1,'2024-01-03')
insert into prodects values(NEWID(),'桌子',4,RAND()*1000,1,'2024-01-04')

insert into prodects values(NEWID(),'书本',1,RAND()*1000,2,'2024-02-01')
insert into prodects values(NEWID(),'笔',2,RAND()*1000,2,'2024-02-02')
insert into prodects values(NEWID(),'手机',3,RAND()*1000,2,'2024-02-03')
insert into prodects values(NEWID(),'桌子',4,RAND()*1000,2,'2024-02-04')

SELECT c.money,pname FROM (SELECT
SUM(money) money,
pname
FROM prodects
group by
months,pname) B right JOIN

(
select max(money) AS money from (SELECT
months ,
SUM(money) money,
pname
FROM prodects
group by
months,pname) a group by months)

C ON B.MONEY =C.money