title: Remove duplicate rows from table with 1 column only?
body: <p>I believe my question was asked on SO, but I didn't find the answer.</p>
  
  <p>There is a mysql table <code>mytable</code> with one column <code>mycolumn</code>.</p>
  
  <p>What is the mysql query to remove duplicates from a table?</p>