Sandnes

Svendson

Stephen

Kaivn 18

Sandnes

  你也能结合AND和OR (使用括号形成复杂的表达式),如:

SELECT * FROM Persons WHERE

(FirstName=''''Tove'''' OR FirstName=''''Stephen'''')

AND LastName=''''Svendson''''

返回结果:

LastName

FirstName

Address

City

Svendson

Tove

Borgvn 23

Sandnes

Svendson

Stephen

Kaivn 18

Sandnes

Between…And

用途：

 指定需返回数据的范围

语法：

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>