T-SQL BETWEEN AND

USE northwind
SELECT UnitPrice
FROM Products
WHERE UnitPrice BETWEEN 50 AND 90
//也可寫成WHERE UnitPrice<90>50

就會取出在Products表格裡UnitPrice欄位中 值有介於50至90的欄位表出來