6. Between查找两个值之间的值的行
BETWEEN 运算符是一个逻辑运算符,用于指定要测试值的范围。
以下是 BETWEEN 运算符的语法:
column | expression BETWEEN start_expression AND end_expression
可以使用大于或等于( >= )且小于或等于( <= )来替换 BETWEEN 运算符,如下所示
column | expression <= end_expression AND column | expression >=
start_expression
使用 BETWEEN 运算符的条件比使用比较运算符 >= , <= 和逻辑运算符AND的条件更具可读性。
要取消 BETWEEN 运算符的结果,请使用 NOT BETWEEN 运算符,如下所示:
column | expression NOT BETWEEN start_expression AND end_expresion </