Home » SQL & PL/SQL » SQL & PL/SQL » Query to find duplicate records
Query to find duplicate records [message #194604] Fri, 22 September 2006 23:02 Go to next message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
hi all,
Can we find duplicate records from a table? As we can use distinct for distinct records.

Best Regards
Fakhar.
Re: Query to find duplicate records [message #194609 is a reply to message #194604] Sat, 23 September 2006 00:05 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Search this site and/or asktom.oracle.com and/or google. This one has been answered many many times.

Ross Leishman
icon2.gif  Re: Query to find duplicate records [message #194627 is a reply to message #194604] Sat, 23 September 2006 01:43 Go to previous message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
first go here
then here
Previous Topic: Finding the Parent Child Relationship between tables
Next Topic: Blobs inserting/viewing
Goto Forum:
  


Current Time: Thu Dec 08 19:54:09 CST 2016

Total time taken to generate the page: 0.11886 seconds