=A1.align@a(A2, STATE)
=A3.new(A2(#):State,~.count():Count)
| A | |
| 1 | =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ") |
| 2 | [New York,Texas,California] |
| 3 |
=A1.align@a(A2, STATE)
|
| 4 |
=A3.new(A2(#):State,~.count():Count)
|
A3中分组结果如下，每个分组均为序列，可双击查看:
A4中的统计结果如下:
