how to find duplicate records in oracle

programming faqs interview questions tech technical educational freshers guide preparation interviews hr telephonic

try another color:

try another fontsize: 60% 70% 80% 90%

User login

Thu, 12/04/2008 - 18:15 — Anonymous

Thu, 12/04/2008 - 18:16 — admin

query is to find duplicate store_numbers in store table

select STORE_NUMBER
from STORE
group by STORE_NUMBER
having count (STORE_NUMBER) > 1

Wed, 05/25/2011 - 13:49 — Anonymous

thanks, above query works for me, i am finding duplicates in contacts table who has the similar firstname,lastname and email.

here is SQL:

SELECT first_name,last_name,count(*)
FROM uk_emea.contacts where deleted=0
group by first_name, last_name, email1 having count(*) > 1