image.png
如需顯示不在上面實(shí)例范圍內(nèi)的網(wǎng)站，請使用 NOT BETWEEN：
SELECT * FROM Websites
WHERE alexa NOT BETWEEN 1 AND 20;
結(jié)果
image.png
BETWEEN 操作符
選取介于兩個(gè)值之間的數(shù)據(jù)范圍內(nèi)的值。這些值可以是數(shù)值暖混、文本或者日期。
BETWEEN 語法
SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;
