Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: to find duplicates

    hi,
    I've a table with 2 columns:
    ID, NAME
    I'd like to find same name with more ID
    How can I write this query?

    Thanks
    Raf

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: to find duplicates

    Originally posted by raf
    hi,
    I've a table with 2 columns:
    ID, NAME
    I'd like to find same name with more ID
    How can I write this query?

    Thanks
    Raf
    SELECT NAME
    FROM table
    GROUP BY NAME
    HAVING COUNT(DISTINCT ID) > 1;

Posting Permissions

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