Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

how to find duplicate records in sqlserver databases

syl73syl73 Member Posts: 1
Hi
i am running a sql server7.0 and front end program in visual basic .. i have around 30,000 records in my database i need to find the duplicate records in my datatbase and have to elliminate them.is there any way i can do this witha query??.Urgent help required ..
thanks in advance..
Selva

Comments

  • paulj59paulj59 Member Posts: 420
    : Hi
    : i am running a sql server7.0 and front end program in visual basic .. i have around 30,000 records in my database i need to find the duplicate records in my datatbase and have to elliminate them.is there any way i can do this witha query??.Urgent help required ..
    : thanks in advance..
    : Selva
    :

    Say your key field is X_ID
    select X_ID from tbl
    group by X_ID
    having count(*)>1
  • Andre YoungAndre Young USAMember Posts: 0

    ______ \ http://forcoder.org \ free video tutorials and ebooks about \ Ruby, Java, JavaScript, Scratch, MATLAB, Visual Basic, PHP, Objective-C, Assembly, Go, Python, Perl, R, Swift, Delphi, PL/SQL, C++, Visual Basic .NET, C, C# Erlang, Prolog, Bash, Awk, Ada, Julia, Rust, Hack, Lisp, FoxPro, Dart, Kotlin, Logo, Crystal, LabVIEW, Fortran, Clojure, Apex, COBOL, VBScript, Scala, ABAP, Scheme, ML, SAS, D, Lua, Alice, F#, Transact-SQL \ ________

Sign In or Register to comment.