oracle 查询重复数据

SELECT * FROM td_attrval_group WHERE parent_attrval_id IN(SELECT parent_attrval_id FROM td_attrval_group GROUP BY parent_attrval_id HAVING COUNT(*) > 1);