SQL BETWEEN 操作符
sql between 操作符
between 操作符用于選取介于兩個值之間的范圍內(nèi)的值。這些值可以是數(shù)值、文本或者日期。
1. between 語法
select column_name(s)
from table_name
where column_name between value1 and value2;
from table_name
where column_name between value1 and value2;