title: How to delete duplicate records mysql
body: <p>i have table </p>
  
  <pre><code>DATE       TRAN_VAL     NAME
  may01         24           hari
  may01         24           hari
  jun22         29           giri
  jun22         29           giri
  dec19         33           niraj
  jan01         56           balu
  </code></pre>
  
  <p>in above table the names hari&amp;giri having complete duplicate records,
  How to remove/delete them
  O/P</p>
  
  <pre><code>DATE       TRAN_VAL     NAME
  may01         24           hari
  jun22         29           giri
  dec19         33           niraj
  jan01         56           balu
  </code></pre>