Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    28

    Unanswered: extracting duplicate record on the same id

    Hi everybody i need help on on a query on how i can extract this... with the following table below..

    id pub
    1 a
    1 b
    2 c
    2 c

    I need to extract only the id and pub where pub has more than one with the same id... in the case of the above the result would be

    id pub

    2 c
    2 c

    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Alex

    Same question recently asked:
    http://www.dbforums.com/showthread.php?t=1620094

    If you are satisfied with only
    2 c

    returned rather than
    2 c
    2 c

    (and the second makes no sense to me BTW) then the first answer by r937 is plenty. Otherwise go down to the bottom for the last answer.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2007
    Posts
    28
    thanks got it..

Posting Permissions

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