列表

详情


MaxCompute SQL的过滤条件where中支持多种过滤条件,包括like、rlike等, 其中rlike是从右向左匹配字符。


A. 对

B. 错

参考答案: B

详细解析:

where语句支持的过滤条件有:>  < == not  not in  like  rlike  between...and。l[font=PingFangSC, "helvetica neue", "hiragino sans gb", arial, "microsoft yahei ui", "microsoft yahei", simsun, sans-serif]ike和rlike的source和pattern参数均仅接受STRING类型。rlike表示只是表示支持正则表达式[/font] [font=PingFangSC, "helvetica neue", "hiragino sans gb", arial, "microsoft yahei ui", "microsoft yahei", simsun, sans-serif][/font] [font=PingFangSC, "helvetica neue", "hiragino sans gb", arial, "microsoft yahei ui", "microsoft yahei", simsun, sans-serif]A RLIKE B:[/font][font=PingFangSC, "helvetica neue", "hiragino sans gb", arial, "microsoft yahei ui", "microsoft yahei", simsun, sans-serif]A是字符串,B是字符串常量或者正则表达式。如果匹配成功,返回TRUE,否则返回FALSE。如果B为空串会报错退出。如果A或B为NULL,返回NULL。[/font][font=PingFangSC, "helvetica neue", "hiragino sans gb", arial, "microsoft yahei ui", "microsoft yahei", simsun, sans-serif][/font]


上一题