| A | B | C | |
| 1 | =file("../FindUsers.txt").import@t() | /52题ti，通过两次解析读出用户编码 | |
| 2 | =A1.run(column_a=column_a.split@b("u?u=").to(2,)) | ||
| 3 | =A2.run(column_a=column_a.(~.split@bp("]")(1))) | ||
| 4 | =A3.news(column_a; A3.id:id,~:result_a) | /使用news函数，根据序列字段生成多条记录 | |
111
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 集算器 | A |
| 1 | =connect(“hsqlDB”) |
| 2 | =A1.query(“select * from order”) |
| 3 | =A2.select(orderDate>=date(“2012-01-01”) && orderDate<date(“2012-02-01”)) |
| 4 | =A3.group(employeeId; |
| 5 | =A4.select(salesAmount>5000) |
| 6 | =A1.query(“select * from orderDetail”) |
| 7 | =join(A3:order,orderId;A6:orderDetail,orderId) |
| 8 | =A7.group(A7.order.employeeId:employeeId;.min(orderDetail.discount):lowestDiscount) |
| 9 | =join(A5:r1,employeeId;A8:r2,employeeId) |
| 10 | =A9.new(r1.employeeId:employeeId,r1.salesAmount:salesAmount,r2.lowestDiscount:lowestDiscount) |
| 11 | >A1.close() |
欢迎来到这里！
我们正在构建一个小众社区，大家在这里相互信任，以平等 • 自由 • 奔放的价值观进行分享交流。最终，希望大家能够找到与自己志同道合的伙伴，共同成长。
注册 关于