query to fetch duplicate records

[ganges]

hi
what is the query to fetch duplicate records in oracle table.

[adam_k]

I think it's the same with SQL:

select field1 ,count(*) from table
group by field1
having count(*) > 1 

or

select * from table
where field1 in 
(select field1 from table
 group by field1
 having count(*) > 1 )

[debasisdas]

What exactly you mean by duplicate records.

Duplicate based on what ?

[rameshbushi]

select <column_name>,count(*) from <table_name> group by <column_name> having count<column_name> >1

[SQLpower]

If you wanna fetch and check through the duplicates, you'd gotta use a cursor.

[adam_k]

@SQLpower: Why?