Howdy, Stranger!

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

Categories

Query To Retrieve Duplicate Records

JerishJerish Member Posts: 3
Hi Guys,

I am using SQL Server 2000 as my database. I need a query for the following purpose.

I have two tables Emp and Emp_Name .

Emp Table has fields like Emp_id (integer),DOB(date),PhoneNo(varchar),.......
Emp_Name has fields like Emp_id (integer),lastname,firstname,middlename,.....

I don't have any Primary key and Foreign Key relation ship between these two tables.

I want to get all the Duplicate Employee related records . ie , I want to get employee details who has same first name , last name , middle name and DOB.

Will a single query do the above job ? please give a exact query for the above one.

Thanks In Advance.


Jerish
[email protected]

Comments

  • abacotandilabacotandil Member Posts: 4

    you don't say if Emp_id is the same or not, i suppose not.

    This is your query, but i don't know if is the exact one.

    select lastname, firstname,middlename, DOB, count(*) as counter from emp table as et join emp_name as en
    where counter > 1
    group by lastname, firstname,middlename, DOB


    be luck, bye.


    : Hi Guys,
    :
    : I am using SQL Server 2000 as my database. I need a query for the following purpose.
    :
    : I have two tables Emp and Emp_Name .
    :
    : Emp Table has fields like Emp_id (integer),DOB(date),PhoneNo(varchar),.......
    : Emp_Name has fields like Emp_id (integer),lastname,firstname,middlename,.....
    :
    : I don't have any Primary key and Foreign Key relation ship between these two tables.
    :
    : I want to get all the Duplicate Employee related records . ie , I want to get employee details who has same first name , last name , middle name and DOB.
    :
    : Will a single query do the above job ? please give a exact query for the above one.
    :
    : Thanks In Advance.
    :
    :
    : Jerish
    : [email protected]
    :

  • Shawn CarterShawn Carter Member Posts: 0

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

Sign In or Register to comment.