假设有一个表如下:
t = table(10:0, ("askPrice" + string(1..50)) join ("AskQty" + string(1..50)), take(DOUBLE, 100));
可以用以下方式实现
sql(sqlColAlias(binaryExpr(sqlCol("askPrice" + string(1..50)), sqlCol("AskQty" + string(1..50)), *), "tradeVol" + string(1..50)), t).eval();