Check For Duplicate Records

SELECT
D_ID
FROM
test_table A
WHERE
rowid >
(SELECT min(rowid) FROM test_table B
WHERE
B.D_ID = A.D_ID
);