可以用元编程的方式:
t = table(1 2 3 4 as event_1_5, 1 3 4 5 as event_2_5, 1 2 3 4 as event_5_1, 1 2 3 4 as event_5_8, 1 2 3 4 as event_6_3) colNames=t.columnNames() s=split(colNames,"_") cols=colNames[each(x->int(x[1])>int(x[2]), s)] sql(select=sqlCol(cols), from=t).eval()