Results 1 to 2 of 2

Thread: duplicated data

  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Unanswered: duplicated data

    I, i need a query please, I have a table with a table column and i need to extract all duplicated email with all the information from is line... the problem is I need to keep all othes fields ex :

    email@email.com Salah Ahmed Hammouda 65187 ATDI
    email@email.com SHEDID OSMAN ZAKARIA 64049 AMS
    email@email.com Shedid Osman Zakaria 98682 ATDI

    is the same person, and a i need to keep just 1 email with 1 information line

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: duplicated data

    Originally posted by superj
    I, i need a query please, I have a table with a table column and i need to extract all duplicated email with all the information from is line... the problem is I need to keep all othes fields ex :

    email@email.com Salah Ahmed Hammouda 65187 ATDI
    email@email.com SHEDID OSMAN ZAKARIA 64049 AMS
    email@email.com Shedid Osman Zakaria 98682 ATDI

    is the same person, and a i need to keep just 1 email with 1 information line
    How do you determine which line to keep? Although they have the same email, some of those names dont seem to match.

Posting Permissions

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