Recursive SQL, have the last three values increased?
- by Mike
Hi,
I have a table that looks like this:
----------------------
| DateTime | Value |
----------------------
| 2010-01-01 | 26 |
| 2010-02-01 | 24 |
| 2010-03-01 | 23 |
| 2010-04-01 | 28 |
| 2010-05-01 | 30 |
I need to find if the last three consecutive months have increased in value.
How can I get SQL to check whether the value for each has increased?
If anyone can give me any pointers for solving this problem it would be greatly appreciated!
Thanks