=A1.group@o(STATE)
=A1.group@n(month(BIRTHDAY))
=A1.group@1(STATE)
| A | |
| 1 | =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ") |
| 2 |
=A1.group@o(STATE)
|
| 3 |
=A1.group@n(month(BIRTHDAY))
|
| 4 |
=A1.group@1(STATE)
|
A2中分组结果如下，每个分组均为排列，可双击查看:
A3中分组结果如下，每个分组均为排列，可双击查看:
A4中分组结果如下，每个州员工仅保留第一条记录:
