There is two way to find duplicate rows first with rowid and second without rowid
With ROWID:
Example:
SELECT rn_product_root__code,
rn_prop_x_cond_x_qual__code
FROM rn_prop_value_root_prmis e
WHERE ROWID NOT IN
(SELECT MIN(ROWID)
FROM rn_prop_value_root_prmis f
WHERE e.rn_product_root__code = f.rn_product_root__code
AND e.rn_prop_x_cond_x_qual__code = f.rn_prop_x_cond_x_qual__code
);
Without ROWID:
Example:
SELECT rn_product__code,
rn_prop_x_cond_x_qual__code,
DECODE(row_number() over( partition BY rn_product__code,rn_prop_x_cond_x_qual__code order by rn_product__code),1,'Not duplicate','Dupilcate') dupicate_criteria
FROM rn_prop_value_prmis;
select name,count(*) from Employee GROUP BY name having count(*)>1 ;
