SQL操作應(yīng)用——between的用法,between限制查詢數(shù)據(jù)范圍時包括了邊界值,not between不包括

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