title: Get the rows those have got changes in a column data
body: <p>I have a sales assignment table that stores the raw data as below.</p>
  
  <pre><code>SaleID     AssignedTo     ModDate
  ---------------------------------
  1          aaaa           1-Aug
  2          bbbb           1-AUg
  3          cccc           1-Aug
  1          eeee           5-Aug
  3          ffff           6-Aug
  </code></pre>
  
  <p>The AssignedTo column in this table might keep changing. 
  I need store the latest record when the AssignedTo changes for each SaleID in another table. Can somebody please help me on how can i identify those records that got changes to AssignedTo fields and store them in other table?</p>
  
  <p>Thanks,
  Venu</p>