oracle 语句联系

create table test
(
  tid Number(10,0) not null primary key,
  col1 varchar2(10) ,
  col2  varchar2(10) ,
  col3  varchar2(10) ,
  col4  varchar2(10)
);

insert into test values(1,'a','aa','aaa','1');
insert into test values(2,'a','aa','aaa','3');
insert into test values(3,'b','bb','bbb','4');
insert into test values(4,'b','bb','bbb','0');
insert into test values(5,'c','cc','ccc','1');
insert into test values(6,'c','cc','ccc','2');
insert into test values(7,'d','dd','ddd','0');
insert into test values(8,'a1','aa1','aaa1','3');
insert into test values(9,'a2','aa2','aaa2','2');
insert into test values(10,'a3','aa3','aaa3','1');

select * from test t
where exists(select 1 from test t2
             where t.col1=t2.col1
               and t.col2=t2.col2
               and t.col3=t2.col3
               and t.col4>t2.col4)