- 论坛徽章:
- 0
|
本帖最后由 alunfirst 于 2018-03-30 16:54 编辑
drop table test
/
create table test
(
id varchar2(20) not null,
day varchar2(20) not null,
value varchar2(20) not null
)
/
insert into test values('1', '20080330', 'b');
insert into test values('1', '20080329', 'b');
insert into test values('1', '20080328', 'b');
insert into test values('1', '20080327', 'a');
insert into test values('1', '20080326', 'a');
insert into test values('2', '20080330', 'b');
insert into test values('2', '20080329', 'b');
insert into test values('2', '20080328', 'a');
insert into test values('2', '20080327', 'a');
insert into test values('2', '20080326', 'a');
insert into test values('3', '20080330', 'a');
insert into test values('3', '20080329', 'b');
insert into test values('3', '20080328', 'b');
insert into test values('3', '20080327', 'a');
insert into test values('3', '20080326', 'a');
commit;
想通过计算3月30日value=b的连续出现次数,得到数据如下:
|
|