-
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]
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|