Lag calculation over in postgresql, PostgreSQL

Lag calculation over in postgresql

Language: Layout:


absolute service time: 0,74 sec

edit mode | history

  
id
date
factor
actual
current

1
1
04.01.2017 00:00:00
0,5000
100
100

2
2
04.02.2017 00:00:00
0,5000
120
100

3
3
04.03.2017 00:00:00
0,5000
120
110

4
4
04.04.2017 00:00:00
0,5000
115
115

5
5
04.05.2017 00:00:00
0,5000
125
115

6
6
04.06.2017 00:00:00
0,5000
100
120

7
7
04.07.2017 00:00:00
0,5000
100
110

λ

                                      .NET NoSQL database for rapid development