Sql - How to display duplicate rows in a table?

[radhika_btech]

Sql - How to display duplicate rows in a table?

[sk_kireeti]

let us assume we have some duplicate records in emp table and we can identify duplicates with empno. The the query looks like this.

Select * from EMP
where
rowid not in
(select max(rowid) from emp group by empno);

The above query displays all duplicate records.

Thanks,
Krishna