I want to compare the rows in table and find mismatches in SQL server 2008 : [enter image description here][1]


  [1]: http://i.stack.imgur.com/SnhyU.png

I want the query which can pull last three rows with all columns and with another column which specifies type of mismatch i.e. accounting, currency..etc.

can any one help me with this?

