Post reply

Removing duplicates based on just one field

  • December 4, 2006 at 8:19 am

    #103280

    I need to remove duplicates based on just one field, not the entire row (which row I retain doesn't seem to matter all that much, since the non-duplication seems to happen in non-essential fields, but I do need to retain all the fields in the row that I do keep)

    Then I need to retain JUST the duplicates based on the same criteria (just the same field as the previous query).

    I will be putting the results of both of these into separate temp tables, from a temp table that has both in it.

    Is this possible?

  • December 4, 2006 at 8:25 am

    #675495

    Please provide the table DDL, some sample data and the required results from that data.  I just don't want to guess at this answer .

  • December 4, 2006 at 8:34 am

    #675497

    I MIGHT have figured out a way to do this, but if it doesn't work, I will try to provide all of these things, and will keep this thread going.

    Thanks for the quick response.

  • December 4, 2006 at 8:37 am

    #675500

    Alright, please post the final answer so that others may benefit from your findings!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply