一个table两列,一个close,一个score,怎么找过去60行最大close时候对应的score
用mimax和rowNo
a=table(rand(1.0,200) as close,rand(1.0,200) as score) r=select score[rowNo(close)-59+mimax(close,60)] from a