FONSI AND & OR don SQL

AND da OR don amfani dashi domin fara kowane wuri tare da tsammanin fiye da ɗaya.

AND da OR don kawo yin amfani dashi

AND da OR ana amfani dashi domin kawo yin amfani dashi tsammanin biyu ko fiye a cikin WHERE tsammanin.

Idan kowane tsammanin farko ko na biyu yake da yawa, AND yana nuna kowane wuri.

Idan kowane tsammanin farko ko na biyu yake da yawa, OR yana nuna kowane wuri.

Tabbin farko (ama a amfani dashi a cikin wasan kwaikwayo):

LastName FirstName Address City
Adams John Oxford Street London
Bush George Fifth Avenue New York
Carter Thomas Changan Street Beijing
Carter William Xuanwumen 10 Beijing

Tukurin AND

Amfani dashi AND don nuna kowane mutum mai suna 'Carter' ko mai suna 'Thomas':

SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'

Shida:

LastName FirstName Address City
Carter Thomas Changan Street Beijing

Tukurin OR

Amfani dashi OR don nuna kowane mutum mai suna 'Carter' ko mai suna 'Thomas':

SELECT * FROM Persons WHERE firstname='Thomas' OR lastname='Carter'

Shida:

LastName FirstName Address City
Carter Thomas Changan Street Beijing
Carter William Xuanwumen 10 Beijing

Amfani dashi AND da OR don kawo yin amfani dashi

Aza ka iya amfani dashi AND da OR don tsammanin da yake (ka amfani dashi kwakwalta don tsammanin da yake zai koyi) :

SELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William')
AND LastName='Carter'

Shida:

LastName FirstName Address City
Carter Thomas Changan Street Beijing
Carter William Xuanwumen 10 Beijing