- 论坛徽章:
- 0
|
这是个相当难度的问题。大侠帮忙呀。急……
给大家个测试数据:
create table testdafe(
ID varchar2(24) NOT NULL,
ttime date ,
tname varchar2(18) ,
taddr varchar2(500), /*A备注*/
primary key (ID)
);
insert into testdafe(id,ttime,tname,taddr) values ('001',to_date('2007-01-01','yyyy-mm-dd'),'张三','场所A');
insert into testdafe(id,ttime,tname,taddr) values ('002',to_date('2007-01-02','yyyy-mm-dd'),'张三','场所A');
insert into testdafe(id,ttime,tname,taddr) values ('003',to_date('2007-01-03','yyyy-mm-dd'),'张三','场所B');
insert into testdafe(id,ttime,tname,taddr) values ('004',to_date('2007-01-04','yyyy-mm-dd'),'张三','场所A');
insert into testdafe(id,ttime,tname,taddr) values ('005',to_date('2007-01-05','yyyy-mm-dd'),'张三','场所C');
insert into testdafe(id,ttime,tname,taddr) values ('006',to_date('2007-01-06','yyyy-mm-dd'),'张三','场所C');
insert into testdafe(id,ttime,tname,taddr) values ('007',to_date('2007-01-07','yyyy-mm-dd'),'张三','场所C');
insert into testdafe(id,ttime,tname,taddr) values ('008',to_date('2007-01-08','yyyy-mm-dd'),'张三','场所A');
[[i] 本帖最后由 yangdafe 于 2007-2-8 09:52 编辑 [/i]] |
|