title: How to get latest records wrt filed 'component'
body: <p>Based on component need to get the latest record where each component may have "n" of tickets but in that few will be cloned for a re-investigation purpose.</p>
  
  <pre><code>  SELECT DISTINCT T.* FROM my_table AS T
  </code></pre>
  
  <p>But i haven't get the perfect answer</p>
  
  <p>Table will be</p>
  
  <pre><code>ID  Summary                         Component   Status
  1   Tyre repairing                  Car         Tested
  2   Glass fitting                   Bus         Tested
  3   Printer repair                  Printer     Confirm
  4   CLONE - Tyre Repair             Car         Tested
  5   Dashboard Clean-up              Car         Confirm
  6   CLONE - CLONE - Tyre Repair     Car         Tested
  7   CLONE - Glass fitting           Bus         Tested
  8   Cleaning                        Computer    Tested
  </code></pre>
  
  <p>Looking for output </p>
  
  <pre><code>ID  Summary                         Component   Status
  3   Printer repair                  Printer     Confirm
  5   Dashboard Clean-up              Car         Confirm
  6   CLONE - CLONE - Tyre Repair     Car         Tested
  7   CLONE - Glass fitting           Bus         Tested
  8   Cleaning                        Computer    Tested
  </code></pre>
  
  <p>Can someone please hep me for the above?
  Thanks,
  Jana</p>