我有如下的表结构:
rq gz lx
2007-01-01 2000 1
2007-01-03 3000 2
2007-02-01 4000 1
2007-02-10 5000 2
2007-03-01 1500 1
2007-03-04 1700 3想得到如下的表结构: rq gz lx lj
2007-01-01 2000 1 2000
2007-01-03 3000 2 3000
2007-02-01 4000 1 6000
2007-02-10 5000 2 8000
2007-03-01 1500 1 7500
2007-03-04 1700 3 1700相同LX的,按月份累计,1月=1月,2月=1月+2月,3月=1月+2月+3月用sql语句该如何实现,请大虾指点。
=========================================
create table test
( rq varchar(20),
gz int,
lx varchar(1)
);
insert into test values('2007-01-01',2000,'1');
insert into test values('2007-01-03',3000,'2');
insert into test values('2007-02-01',4000,'1');
insert into test values('2007-02-10',5000,'2');
insert into test values('2007-03-01',1500,'1');
insert into test values('2007-03-04',1700,'3');
commit;
rq gz lx
2007-01-01 2000 1
2007-01-03 3000 2
2007-02-01 4000 1
2007-02-10 5000 2
2007-03-01 1500 1
2007-03-04 1700 3想得到如下的表结构: rq gz lx lj
2007-01-01 2000 1 2000
2007-01-03 3000 2 3000
2007-02-01 4000 1 6000
2007-02-10 5000 2 8000
2007-03-01 1500 1 7500
2007-03-04 1700 3 1700相同LX的,按月份累计,1月=1月,2月=1月+2月,3月=1月+2月+3月用sql语句该如何实现,请大虾指点。
=========================================
create table test
( rq varchar(20),
gz int,
lx varchar(1)
);
insert into test values('2007-01-01',2000,'1');
insert into test values('2007-01-03',3000,'2');
insert into test values('2007-02-01',4000,'1');
insert into test values('2007-02-10',5000,'2');
insert into test values('2007-03-01',1500,'1');
insert into test values('2007-03-04',1700,'3');
commit;
from test a
order by a.rq, a.lx