How to find duplicate records from two tables..? RRS feed

  • Question

  • I have a table in SQL Server and the name of the table is "Employee"

    Also i have some records in that table.

    I have another Data table called "Dt1".  I just want to compare these two tables and find out the new records and duplicate records.

    how to merge and get output (new list and duplicate) as datatable table after comparing of Employee and Dt1 table..

    Sample table and output as mentioned in the screenshot (attached).

    Thursday, June 7, 2018 12:49 PM


All replies