17,082
社区成员
发帖
与我相关
我的任务
分享
--3天以内5次交易大于10000
SELECT A.NAME,
A.NAME2,
A.MON,
A.T_DATE,
A.SAL,
COUNT(A.SAL) OVER(PARTITION BY A.NAME, A.NAME2 ORDER BY A.T_DATE RANGE BETWEEN 2 PRECEDING AND 0 FOLLOWING)AS "交易次数",
SUM(A.SAL) OVER(PARTITION BY A.NAME,A.NAME2 ORDER BY A.NAME,A.NAME2A.T_DATE, A.SAL DESC RANGE BETWEEN 2 PRECEDING AND 0 FOLLOWING) AS "3天单人最大交易额"
FROM WXJ1 A;
NAME NAME2 MON T_DATE SAL ROWID
1 A B 10 1 123123 AAASg6AAFAAAACTAAA
2 A C 10 1 3434 AAASg6AAFAAAACTAAB
3 A B 10 1 456456 AAASg6AAFAAAACTAAC
4 A 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 B 10 3 12 AAASg6AAFAAAACXAAA