insert into (1,22,1);
insert into (2,12,1);
insert into (3,2,1);
insert into (4,22,2);
insert into (5,22,2);
insert into (6,22,2);
insert into (7,22,2);
insert into (8,22,2);
insert into (9,22,3);
insert into (10,22,3);
我想要查询出 card 相同的时候 number的总和
...全文
8110打赏收藏
查询请教
create table aa{ id int , number int, card int } insert into (1,22,1); insert into (2,12,1); insert into (3,2,1); insert into (4,22,2); insert into (5,22,2); insert into (6,22,2); insert into (7,22,2); insert into (8,22,2); insert into (9,22,3); inse
create table aa{
id int ,
number int,
card int,
info int,
date Date,
server int
}
我要查看在的是 info以纵行显示,如果date相同 info相同 就把number相加,
所以date和info都要分组 我写得sql是
select sum(number) from aa where server=1 and date='2011-02-11'
group by info,date
这样是错的,他虽然sum中结果能够统计的正确,但是info和date就会重复显示
我要的是在指定某一时间的info里面的相同数据 也就是number能够加载一起