SQL操作應用——between的用法,between限制查詢數據范圍時包括了邊界值,not between不包括

between的用法,between限制查詢數據范圍時包括了邊界值,not between不包括
select * from table1 where time between time1 and time2
select a,b,c, from table1 where a not between 數值1 and 數值2