| A | |
| 1 |
 =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ")
|
| 2 |
=A1.new(FULLNAME:EName,if (GENDER =="M", "Male","Female"):Gender)
|
| 3 |
=A1.new(EID, FULLNAME, interval@y(BIRTHDAY,now()):Age)
|
A2、A3中的运算结果如下:
