SQL BETWEEN 操作符

sql between 操作符

between 操作符用于选取介于两个值之间的范围内的值。这些值可以是数值、文本或者日期。

 

1. between 语法

select column_name(s)
from table_name
where column_name between value1 and value2;
相关文章