=demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ").derive(interval@y(BIRTHDAY,now()):Age)
=A1.sort(STATE)
=A1.sort(SALARY:-1)
=A1.sort(SALARY:-1, FULLNAME)
| A | |
| 1 |
=demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ").derive(interval@y(BIRTHDAY,now()):Age)
|
| 2 |
=A1.sort(STATE)
|
| 3 |
=A1.sort(SALARY:-1)
|
| 4 |
=A1.sort(SALARY:-1, FULLNAME)
|
A2中的运算结果如下:
A3中的运算结果如下:
A4中的运算结果如下:
