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

    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.


  2. #2
    Join Date
    Jul 2002
    Village, MD
    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