title: How to remove duplicate rows except one?
body: <p>On <code>mytable</code> no column is primary :</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Name</th>
  <th>Company</th>
  <th>Position</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Michael</td>
  <td>Google</td>
  <td>Tester</td>
  </tr>
  <tr>
  <td>Michael</td>
  <td>Google</td>
  <td>Tester</td>
  </tr>
  <tr>
  <td>Michael</td>
  <td>Google</td>
  <td>Tester</td>
  </tr>
  <tr>
  <td>Peter</td>
  <td>Facebook</td>
  <td>Developer</td>
  </tr>
  <tr>
  <td>Peter</td>
  <td>Facebook</td>
  <td>Developer</td>
  </tr>
  <tr>
  <td>Peter</td>
  <td>Facebook</td>
  <td>Developer</td>
  </tr>
  <tr>
  <td>Peter</td>
  <td>Facebook</td>
  <td>Developer</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>What I want :</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Name</th>
  <th>Company</th>
  <th>Position</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Michael</td>
  <td>Google</td>
  <td>Tester</td>
  </tr>
  <tr>
  <td>Peter</td>
  <td>Facebook</td>
  <td>Developer</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This does not work :</p>
  <pre><code>DELETE FROM
     mytable
  WHERE
     Name NOT IN (
        SELECT
           MAX(Name)
        FROM
           mytable
        GROUP BY
           Company
     )
  ;
  </code></pre>
  <p>Without new table creation and no CTE, how can I remove duplicate rows except one?</p>