Results 1 to 2 of 2

Thread: SQL Question

  1. #1
    Join Date
    Oct 2002
    Charlotte, NC

    Unhappy Unanswered: SQL Question

    Can someone help me out with this SQL problem?

    Suppose I had the following information in a table:

    <Test> <Question#> <Answer>
    1 1 A
    1 2 D
    1 3 C
    1 4 A
    1 5 C
    1 5 B
    1 6 A
    1 7 D
    1 7 B
    1 8 C

    I need an SQL statement that will look for duplicate <Question#> and remove the 1st record instance... and leave the 2nd record.

    This is a random problem.. so next time.. it might be question 3 and 6 that contains a duplicate entry.

    Thanks for any help

    "How much deeper would the ocean be without sponges?"

  2. #2
    Join Date
    Aug 2002
    Charlotte NC
    if you are in access 2000 there should be a find duplicate wizard when you go to create a new query. look at that in sql view and see if that helps

Posting Permissions

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