title: deleting duplicate row with no unique identifier
body: <p>I have some data in a table that looks roughly like the following:</p>
  
  <pre><code>table stockData
  (
  tickId int not null,
  timestamp datetime not null,
  price decimal(18,5) not null
  )
  </code></pre>
  
  <p>Neither tickId nor timestamp are unique, however the combination of tickId and timestamp is supposed to be unique.</p>
  
  <p>I have some duplicate data in my table, and I'm attempting to remove it.  However, I'm coming to the conclusion that there is not enough information with the given data for me to discern one row from the other, and basically no way for me to delete just one of the duplicate rows.  My guess is that I will need to introduce some sort of identity column, which would help me to identify one row from the other.</p>
  
  <p>Is this correct, or is there some magic way of deleting one but not both of the duplicate data with a query?</p>
  
  <p><strong>EDIT</strong> Edited to clarify that tickId and timestamp combo should be unique, but it's not because of the duplicate data.</p>