为” Svendson”的数据
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
Borgvn 23 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |