从数据库中的SALES表中获得销售数据,找出历年销售额均在前15位的客户有哪些。
解答:
A | |
1 |
![]() =demo.query("select * from SALES")
|
2 |
![]() =A1.group(year(ORDERDATE))
|
3 |
![]() =A2.(~.group(CLIENT))
|
4 |
![]() =A3.(~.new(CLIENT,~.sum(AMOUNT):Amount))
|
5 |
![]() =A4.(~.sort@z(Amount).select(#<=15))
|
6 |
![]() =A5.(~.(CLIENT))
|
7 |
![]() =A6.isect()
|
A7中运算结果如下: