| 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() | | | |
欢迎来到这里！
我们正在构建一个小众社区，大家在这里相互信任，以平等 • 自由 • 奔放的价值观进行分享交流。最终，希望大家能够找到与自己志同道合的伙伴，共同成长。
注册 关于