SELECT one record every 15 minuts for the last 2 weeks.
I need to construct a query that will select the first timestamp every 15 minutes for the last two weeks.
Something like this:
SELECT datetime_field FROM table WHERE datetime_field > (2weeks ago)
I can get it to work, but not in intervals of 15minutes.
There could be hundreds of records every 15min, but I just want the first one. Can anyone help?
Subject
Written By
Posted
SELECT one record every 15 minuts for the last 2 weeks.
March 05, 2012 02:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.