title: Delete duplicate rows in sqlite database
body: <p>I want to delete duplicate rows in a sqlite database. I found this code online to do it:</p>
  <pre><code>DELETE FROM table1
  WHERE ROWID NOT IN (
      SELECT min(rowid)
      FROM table1
      GROUP BY col1, col2
  )
  </code></pre>
  <p>But the issue is that my database contains 50+ columns and I don't want to write all the column names in group by. Is there a workaround to group by all the columns?</p>
  <p>I am new to this so I may be missing something simple.</p>