◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。
select a. id ,a. 规格,count( 售价) as 次数 from a表,b表 where a.id=b.id group by b.id ,b.规格
create table t1
( id int,
bianma varchar(20),
name varchar (20),
sell int,
addtime date
)
insert into t1 (id,bianma ,name,sell,addtime) values (11,'001','A',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (12,'001','A',15,'')
insert into t1 (id,bianma ,name,sell,addtime) values (12,'002','B',15,'')
insert into t1 (id,bianma ,name,sell,addtime) values (12,'002','B',15,'')
insert into t1 (id,bianma ,name,sell,addtime) values (13,'002','B',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (14,'002','B',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (15,'002','B',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (16,'002','B',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (17,'002','B',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (18,'003','C',10,'')
insert into t1 (id,bianma ,name,sell,addtime) values (19,'003','C',10,'')
SELECT bianma ,name ,
isnull(SUM(case when addtime between '' and '' then sell end ),0) as [14年12月],
ISNULL(SUM(case when addtime between '' and '' then sell end ),0) as [15年1月],
ISNULL(SUM(case when addtime between '' and '' then sell end ),0) as [15年2月]
from t1
group by bianma,name
◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。
工作时间:8:00-18:00
电子邮件
11694635119@qq.com
扫码二维码
获取最新动态