Query Help

[ocyrus27]

I want to be able to check for duplicate rows in a column. The actual data in the column is based on a tree stucture.

So if


.........................................A

.............................B..........C...........B




Disregard the(.............) for display reasons only



So If all of these are in a table called cat and they all have a ID. Also there is a table called cat_rel that will display the parent cat to child cat relationship.
So I would want this diagram above to look like this:

A B
A B


Only giving me the duplicates.


here is the query I have so far:


select level, give_me_name(child_Cat_id)
from cat_rel
connect by parent_Cat_id=prior child_cat_id
start with parent_cat_id in (select cat_id from store_root_Cat where store_id=21)
group by level, give_me_name(child_Cat_id)
having count(*) > 1


Thanks
Fran

[Edited by ocyrus27 on 02-06-2001 at 12:19 PM]

[ocyrus27]

Please help