具体描述不出来,看图片:
附上建表语句:
create table TAB1
(
id VARCHAR2(6),
iname VARCHAR2(20),
sno VARCHAR2(6)
)
insert into tab1(id,iname,sno) values('1001','abcde','s001');
insert into tab1(id,iname,sno) values('1002','hijk','s002');
insert into tab1(id,iname,sno) values('1002','hijk','s003');
insert into tab1(id,iname,sno) values('1003','xyz','s001');
insert into tab1(id,iname,sno) values('1003','xyz','s003');
insert into tab1(id,iname,sno) values('1003','xyz','s004');
insert into tab1(id,