How to find the duplicate rows for multiple columns in a sql query

Ranjith_1996

Hi,

I am having around 200 columns in a select query. And the query output is having greater than 3000 rows. So, I want to know, is there any way to find duplicate rows present in the sql query output?

Is it possible to find? Any help would be really helpful. Thanks in Advance.

<

Suresh Sangaran-Oracle

WITH dup_count AS( SELECT
    t.*,
    COUNT(*) over (PARTITION BY col1, col2, <add_your_columns_here>) c
FROM tab1 t )
SELECT * FROM dup_count
 WHERE c > 1;

Use Analytics function.