title: Delete Every Alternate Row in SQL
body: <p>I need to clean up a table which has three columns, ID (uniqueidentifier), Observation (nvarchar), and Timestamp (datetimeoffset). The content is generated by two sensors at 1 hour interval, and the value of Observation is the same from the two sensors. My idea is to do a SELECT query such as</p>
  
  <pre><code>SELECT * FROM [Records] ORDER BY [Timestamp]
  </code></pre>
  
  <p>and then delete every alternate row.</p>
  
  <p>I found this on SO <a href="https://stackoverflow.com/questions/2361466/how-to-delete-every-alternate-row-in-access-table">how to delete every alternate row in access table</a>, but doesn't really applies here as the ID is not Int but UID.</p>
  
  <p>A sample of the data would look like:</p>
  
  <p><img src="https://i.stack.imgur.com/1sMM2.png" alt="enter image description here"></p>