How to compare two table column values using SQL Server?

Question

Need only differing rows values from two tables

Like..

ID  Name    Salary
1   ABC     2000
2   XYZ     4000
3   Suresh  6000

ID  Name    Salary
1   ABC     3000
2   XYZ     5000
3   Suresh  6000

If I update first table, here I saved particular row in destination table from source table based on condition, now I want to compare two table's column values.. Which column values are updated... Please help me

 ID    OldSalary       NewSalary
  1      2000             3000
  2      4000             5000

Alex Sikilinda · Accepted Answer · 2015-07-02 19:09:37Z

2

Here you go:

select newTable.ID, oldTable.Salary as OldSalary, newTable.Salary as NewSalary
from oldTable 
    join newTable on oldTable.ID = newTable.ID
where oldTable.Salary <> newTable.Salary;

edited Jul 2, 2015 at 19:09

answered Jul 1, 2015 at 15:49

Alex Sikilinda

3,03321 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to compare two table column values using SQL Server?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related