Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Unanswered: Finding duplicate values in fields

    Hi everyone..

    I have a table with about 40,000 records in it.
    I want to find records where all of the values in all of the fields, except for the unique field are equal.

    The records in this table are answers to a online survey.

    So, I want to find all of the records where people answered the questions exactly the same as someone else.


    Any help would be appreciated.

    Nickie

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    What about this:

    select list of fields
    from yourtable
    group by list of fields having count(*)>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
  •