I need the query which will fetch the data from DATE_TIME1 to DATE_TIME2 with interval of 2min or 3 min or 15 min which is variable.
The DATE_TIME data is available in the table in the interval of 1 min.
ex in the table:
I want query should be like this, fetch the data from table1 where DATE_TIME is between 29-Aug-2009 10:00:00 and 29-Aug-2009 10:30:00 with interval of 2 min. The out put of query will like this.
Please help me to make query to meet result of query.
Thanks in advance.