Filtering SQL Rows based on timestamp

I have a query that is based on timestamp.

Sometimes my update to sql procedure hits twice within the same second thus producing identical rows with timestamps only differing a few seconds. Any idea how to create a WHERE clause that filters out rows where the timestamp distance with its above row are less than a minute? Thanks.

https://stackoverflow.com/questions/66683973/filtering-sql-rows-based-on-timestamp March 18, 2021 at 10:35AM