DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Query Help

  1. #1
    Join Date
    Feb 2001
    Posts
    2
    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]

  2. #2
    Join Date
    Feb 2001
    Posts
    2

    Please help

    Please help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width