用rowAnd函数,select * from table where rowAnd((col1,col2, ... col32)<0.5),例如下表:
t=table(1..3 as code,0.4 0.5 0.6 as col1,0.4 0.5 0.6 as col2,0.4 0.5 0.6 as col3,0.4 0.5 0.6 as col4) select * from t where rowAnd((col1,col2, col3,col4)<0.5)
返回:
code col1 col2 col3 col4 1 0.4 0.4 0.4 0.4