title: Delete multiple rows and keep only one for each id
body: <p>I have  table that looks like this that has two columns:</p>
  
  <ol>
  <li>id</li>
  <li>name</li>
  </ol>
  
  <p>I have multiple records and some of them has the same id, I want to delete all the duplicates and only keep one id for each row.</p>
  
  <p>So I have the data like this:</p>
  
  <pre><code>id: 1
  name: Test1
  
  id: 1
  name: Test1
  
  id: 2
  name: Test1
  
  id: 2
  name: Test1
  
  id: 2
  name: Test1
  
  id: 3
  name: Test1
  </code></pre>
  
  <p>And want it to be like this instead:</p>
  
  <pre><code>id: 1
  name: Test1
  
  id: 2
  name: Test1
  
  id: 3
  name: Test1
  </code></pre>
  
  <p>Any ideas how to achieve this? I have tried <a href="https://stackoverflow.com/questions/8190541/deleting-duplicate-rows-from-sqlite-database#8190671">this</a> answer but it returned all rows with id 1...</p>