会python真的可以为所欲为0(回)
350天前
这里还有人吗1(回)
535天前这里还有人吗0(回)
535天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
760天前到处都是羊，不想上班0(回)
840天前
鸽子
0(回)
844天前insert into tb(id,product,area,num) |
select 1,'A','长沙',1 from dual union |
select 2,'A','长沙',2 from dual union |
select 3,'A','北京',3 from dual union |
select 4,'A','北京',4 from dual union |
select 5,'B','上海',1 from dual union |
select 6,'B','广州',2 from dual union |
select 7,'B','深圳',3 from dual; |
|
|
select * from tb; |
--方法1 |
select product 商品,sum(type) 城市数,sum(num) 数量 from ( |
select product ,area ,sum(num) num,1 type from tb |
group by product,area |
)group by product; |
--方法2 |
select product 商品,count(distinct(area)) 城市数,sum(num) 数量 from tb group by product; |
by: 发表于：2017-09-28 14:49:30 顶(0) | 踩(0) 回复
？？
回复评论