Hi,
i am putting here the sample data, and would like to display all duplicate records.
I have data like below in table.
Currently i can be able to display the duplicate records using below query like this.
But i wanted to display all duplicate records, like below
A B C D
----------------------
1 2 3 NULL
1 2 3 NULL
1 2 3 NULL
I tried using below query
SELECT * FROM T10 WHERE (A,B,C,D) IN (
SELECT A,B,C,D FROM T10 WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM T10 GROUP BY A,B,C))
But its returning me 0 records, might be due to having NULL values.
Please suggest me the query.
Script for the sample data
=======================
CREATE TABLE T10 (A NUMBER,B NUMBER,C NUMBER, D NUMBER);
INSERT INTO T10 VALUES (1,2,3,null);
INSERT INTO T10 VALUES (1,2,3,null);
INSERT INTO T10 VALUES (1,2,3,null);
INSERT INTO T10 VALUES (1,2,4,null);
INSERT INTO T10 VALUES (1,null,3,6);