Dear All,
I need help in writing a query and would appreciate any solution that would solve my problem :) Some background information:
I have a table which records the price of a commodity at a given date and time (5 minute increment to be exact). The first column represents the Date. Second column represent the time and the third column is the price. The time span for this table is for a whole year. An extract of the table is as follow:
1999/1/5 09:05 6430
1999/1/5 09:10 6355
1999/1/5 09:15 6365
1999/1/5 09:20 6354
1999/1/5 09:25 6321
next day
1999/1/6 09:05 6011
1999/1/6 09:10 6050
1999/1/6 09:15 6093
1999/1/6 09:20 6080
1999/1/6 09:25 6065
to last day of the year
1999/12/28 09:05 8560
1999/12/28 09:10 8520
1999/12/28 09:15 8500
1999/12/28 09:20 8500
1999/12/28 09:25 8505
Here is my question :
The query I would like to write is to find the days in which the price at 9:15 is higher than the price at 9:10 and the price at 9:10 is also higher than the price at 9:05!
I have no idea how to write this in SQL and would love to hear any tips from you!