=A1.group(STATE)
=A1.group(STATE, GENDER)
=A2.new(~.STATE:State,~.count():Count)
=A3.new(~.STATE:State,~. GENDER:Gender, ~.count():Count)
| A | |
| 1 | =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ") |
| 2 |
=A1.group(STATE)
|
| 3 |
=A1.group(STATE, GENDER)
|
| 4 |
=A2.new(~.STATE:State,~.count():Count)
|
| 5 |
=A3.new(~.STATE:State,~. GENDER:Gender, ~.count():Count)
|
A2与A3中的运算结果如下，每个分组均为排列，可双击查看:
A4与A5中的统计结果如下:
