t=table(1..10 as colA,11..20 as colB,21..30 as colC) def funcTest(colA,colB,colC){ ret1=colA*10 ret2=colB*10 ret3=colC*10 return ret1,ret2,ret3 } select funcTest(colA,colB,colC) as `a`b`c from t
显示如下:
a b c 10 110 210 20 120 220 30 130 230 40 140 240 50 150 250 60 160 260 70 170 270 80 180 280 90 190 290 100 200 300