=A1.enum(A2, SALARY)
=A3.new(#:Group,~.count():Count)
=A1.enum(A5, SALARY)
=A6.new(#:Group,~.count():Count)
| A | |
| 1 | =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ") |
| 2 | [?<8000,?<12000,?>=12000] |
| 3 |
=A1.enum(A2, SALARY)
|
| 4 |
=A3.new(#:Group,~.count():Count)
|
| 5 | [?<8000,?<10000,?<12000,null] |
| 6 |
=A1.enum(A5, SALARY)
|
| 7 |
=A6.new(#:Group,~.count():Count)
|
A3中分组结果如下，每个分组均为排列，可双击查看:
A4中的统计结果如下:
A6中分组结果如下，每个分组均为排列，可双击查看:
A7中的统计结果如下:
