SELECT * FROM Persons

WHERE FirstName=''''Tove''''

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

返回结果:

LastName

FirstName

Address

City

Svendson

Tove

Borgvn 23

Sandnes

用OR运算子来查找"Persons" 表中FirstName为”Tove”或者LastName为” Svendson”的数据

SELECT * FROM Persons

WHERE firstname=''''Tove''''

OR lastname=''''Svendson''''

返回结果:

LastName

FirstName

Address

City

Svendson

Tove

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