title: delete duplicate rows and need to keep one from all of them in mysql
body: <p>I want to delete duplicate rows based on two columns but need to keep 1 row all of them.</p>
  
  <p>Duplicate rows can be more than two rows like,</p>
  
  <pre><code>ID  NAME PHONE
  --  ---- ----
  1   NIL  1234 
  2   NIL  1234 
  3   NIL  1234 
  4   MES  5989
  </code></pre>
  
  <p>I want to delete any of 2 rows from above 3 and keep 1 row.</p>