Home » SQL & PL/SQL » SQL & PL/SQL » How to choose duplicate records (tuples)?
How to choose duplicate records (tuples)? [message #353] Wed, 06 February 2002 11:33 Go to next message
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?
Re: How to choose duplicate records (tuples)? [message #356 is a reply to message #353] Wed, 06 February 2002 13:33 Go to previous message
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: Sat Sep 18 05:50:54 CDT 2021