I’ve seen a lot of grouping by timestamps with fixed intervals (e.g. 0-10, 11-20 mins) etc. However I want to identify duplicated in a database which have similar timestamps, that could span these fixed width intervals e.g. 10:09 and 10:11.

What’s the best approach to find all the “unique” entries, grabbing only the first entry where the timestamps are +/- 5 minutes on the others.

Thanks