I have a table where I make a record every minute. The column where I keep the time of each insertion is of type TIME . I want to make a query that I select the records that with an interval of 2 minutes.
I mean, show me something similar to this:
Column 01:00:00, 01:02:00, 01:04:00, 01:06:00, 01:08:00, 01:10:00, 01:12 : 00, etc ...
The column of my table is as follows: