SQL Server查询分类汇总

最新推荐文章于 2024-02-29 19:11:30 发布

Backcanhave7

最新推荐文章于 2024-02-29 19:11:30 发布

阅读量3.9k

点赞数 2

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qq_41080850/article/details/94714748

构建测试数据：

-- 判断是否已存在名为sales的表，若存在，则删除：
if object_id('sales','U') is not null
drop table sales

-- 创建新的销售表sales:
create table sales(
year    int,
country varchar(20),
product varchar(32),
profit  int
)
 
-- 向销售表sales中插入数据：
insert into sales values(2000,'USA','Calculator',105)
insert into sales values(2000,'USA','Computer',1500)
insert into sales values(2000,'USA','TV',1350)
insert into sales values(2000,'USA','Calculator',50)
insert into sales values(2000,'USA','Computer',2500)
insert into sales values(2000,'USA','Phone',3100)
insert into sales values(2001,'USA','Computer',1200)
insert into sales values(2001,'USA','TV',3050)
insert into sales values(2001,'USA','TV',2000)
insert into sales values(2000,'Finland','Computer',1500)
insert into sales values(2000,'Finland','Phone',1000)
insert into sales values(2001,'Finland','Phone',2500)
insert into sales values(2000,'India','Calculator',150)
insert into sales values(2000,'In