Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: duplicates in a table

    Select count (*) from tower.nbdocdeletedrecords
    Where scandate = '12/13/2008'
    and slevel = 6
    Returns 5798 records


    select distinct towid from tower.NBdocdeletedrecords where slevel=6 and scandate = '12/13/2008' and username = 'SQLKofc'
    returns 2899 records which is correct

    How do I delete the duplicates???

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What version of SQL Server?
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    SQL Server 2000 SP4 Enterprise Edition

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You have different criteria in your WHERE clauses. That may be a large part of your problem.

    -PatP

Posting Permissions

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