title: SQL Query to get the emp and corresponding manager from Emp Audit table
body: <p>I have employee audit table which has the multiple row of each employee. EX:Emp_Table</p>
  
  <pre><code>Emp_id Manager_id Date
  1         1       Sep'13
  1         2       Sep'13  
  1         3       Oct'13
  2         1       Jan'13
  2         1       Feb'13
  3         1       Jan'13
  3         1       Mar'13
  3         2       Feb'13
  3         2       Jan'13
  </code></pre>
  
  <p>Output I'm looking for the table is</p>
  
  <blockquote>
    <p>Latest employee changes Rows</p>
  </blockquote>
  
  <p>According to the table above following output is required</p>
  
  <pre><code>  Emp_id  Manager_id   Date
      1         3       Oct'13  
      2         1       Feb'13
      3         1       Mar'13
  </code></pre>
  
  <p>I tried the below query</p>
  
  <pre><code>select emp_id,Manager_id,MAX(Date)
  from Emp_Table
  Group by emplid
  </code></pre>