Alert based on a value of previous row
On a db level there are analytical functions 'LOG' which allows to compare the previous value, but my task is to create the alerter which sends e-mail if next value is greater than current one.
I know that there is a functions previous() etc, but how to implement this, maybe smb can elighten me on this.
ID DATE TRANSACTION COUNT
1 01.01.2014 1120
2 02.01.2014 1099
3 03.01.2014 1700 --> Alert is triggered
SO, for the last value alert has to be triggered and sent to E-mail. On DB level i see no problems implementing this, but how to implement this in Crystal?