sys@ORCL.world|SQL>create table t1 (num number, str varchar2(30));
Table created.
sys@ORCL.world|SQL>insert into t1(num,str) values(1,'one');
1 row created.
sys@ORCL.world|SQL>insert into t1(num,str) values(1,'one');
1 row created.
sys@ORCL.world|SQL>insert into t1(num,str) values(2,'two');
1 row created.
sys@ORCL.world|SQL>commit;
Commit complete.
sys@ORCL.world|SQL>select * from t1 group by num, str having count(1) >1;
NUM STR
---------- ------------------------------
1 one
sys@ORCL.world|SQL>drop table t1;
Table dropped.
|