, why is this an error ORA - 30486-CodePudding

 
- 5 times within 3 days of trading is more than 10000 
The SELECT A.N AME, 
A.N AME2, 
Arjun ON, 
A.T _DATE, 
A.S AL, 
COUNT (A.S AL) OVER (PARTITION BY A.N AME, A.N AME2 ORDER BY A.T _DATE RANGE BETWEEN 2 PRECEDING AND FOLLOWING 0) AS "transaction number", 
The SUM (A.S AL) OVER (PARTITION BY A.N AME, A.N AME2 ORDER BY A.N AME, A.N. AME2A T_DATE, A.S AL DESC RANGE BETWEEN 2 PRECEDING AND FOLLOWING 0) AS "3 single biggest trading day" 
The FROM WXJ1 A;

An error ORA - 30486: invalid window aggregation group in the window specification
Excuse me this what problem;

 NAME NAME2 MON T_DATE SAL ROWID 
1 B, 10 1 123123 AAASg6AAFAAAACTAAA 
2 A C 10 1 3434 AAASg6AAFAAAACTAAB 
3 B, 10 1 456456 AAASg6AAFAAAACTAAC 
4 B, 10 2 678678 AAASg6AAFAAAACTAAD 
5 B C 10 2 12 AAASg6AAFAAAACTAAE 
6 B D 10 3 222 AAASg6AAFAAAACTAAF 
7 B A 10 4 123123 AAASg6AAFAAAACTAAG 
8 B C 10 4 3434 AAASg6AAFAAAACTAAH 
9 D B 10 4 1 AAASg6AAFAAAACTAAI 
10 C B 10 5 2 AAASg6AAFAAAACTAAJ 
11 B C 10 6 3 AAASg6AAFAAAACTAAK 
12 B D 10 7 4 AAASg6AAFAAAACTAAL 
13 A 10 3 12 AAASg6AAFAAAACXAAA B

CodePudding user response:

A.N AME2A T_DATE, add a comma here