SELECT column_name FROM table_nameWHERE column_name BETWEEN value1 AND value2
例:
“Persons”表中的原始数据
LastName
FirstName
Address
City
Hansen
Ola
Timoteivn 10
Sandnes
Nordmann
Anna
Neset 18
Sandnes
Pettersen
Kari
Storgt 20
Stavanger
Svendson
Tove
Borgvn 23
Sandnes
用BETWEEN…AND返回LastName为从”Hansen”到 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |