title: Get the last update time for each employee using oracle query
body: <p>I have tried the below query to get the last update value.. But I can't get single row for each employee</p>
  
  <pre><code>select distinct Employee_name,Employee_status,update_time
    from Employee 
   where Employee_name= 'Muthukumar'
     and Employee_status='ACTIVE' 
   order by Employee_name, Update_time desc
  
  Employee_name       Employee_status  Update_time
  Muthukumar          ACTIVE           06-DEC-12 10.18.59.048000000 AM
  Muthukumar          ACTIVE           05-DEC-12 05.05.41.165000000 AM
  Muthukumar          ACTIVE           04-SEP-12 03.00.54.706000000 AM
  </code></pre>
  
  <p>Like this i will have entries for different employees. I need to get a single row for each employee with only last updated time.( Highest)</p>
  
  <p>Output should be :</p>
  
  <pre><code>Employee_name  Employee_status   Update_time
  Muthukumar     ACTIVE            06-DEC-12 10.18.59.048000000 AM
  </code></pre>