sum following rows in each partition , Oracle

sum following rows in each partition

Language: Layout:


absolute service time: 1,44 sec

edit mode | history

  
MTD
ID
ACTV
CNT

1
01.04.2016 00:00:00
a
y
2

2
01.05.2016 00:00:00
a
y
1

3
01.06.2016 00:00:00
a
n
1

4
01.07.2016 00:00:00
a
y
0

5
01.08.2016 00:00:00
a
n
0

6
01.04.2016 00:00:00
b
n
4

7
01.05.2016 00:00:00
b
y
3

8
01.06.2016 00:00:00
b
y
2

9
01.07.2016 00:00:00
b
y
1

10
01.08.2016 00:00:00
b
y
0

λ

                                      .NET NoSQL database for rapid development