OraFAQ Forum: SQL & PL/SQL » How to choose duplicate records (tuples)?

Home » SQL & PL/SQL » SQL & PL/SQL » How to choose duplicate records (tuples)?

Wed, 06 February 2002 11:33

Chen Wen
Messages: 26
Registered: February 2002

Junior Member

Anyone could tell me how to choose duplicate
records in one tabel with all the same attribute
values?

Wed, 06 February 2002 13:33

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select col1,col2 from tab1
group by col1,col2
having count(*)>1;

Previous Topic:	Indexes
Next Topic:	Re: redundant indexes

Goto Forum:

]

Current Time: Tue Apr 23 21:41:09 CDT 2024