what is the query to fetch duplicate records in oracle table.
Jump to Post
I think it's the same with SQL:
select field1 ,count(*) from table group by field1 having count(*) > 1
select * from table where field1 in (select field1 from table group by field1 having count(*) > 1 )
All 5 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.