SQL and & OR operator

The and and or operators are used to filter records based on more than one condition.

And and OR operators

And and or can combine two or more conditions in a where sub-statement.

Assuming that the first condition and the second condition are true, the AND operator displays a record.

Assuming that only one of the first and second conditions is true, the OR operator displays a record.

The original table (used in the sample): City

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

And operator instances

Use and to display all people named "Carter" with the name "Thomas":

ANDLastname= ' Carter '

Results:

LastName	FirstName	Address	City
Carter	Thomas	Changan Street	Beijing

An OR operator instance

Use or to display all people whose last name is "Carter" or "Thomas":

ORLastname= ' Carter '

Results:

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

Combine and and OR operators

We can also combine and and or together (using parentheses to form complex expressions):

(ORFirstname= ' William ' ) AND lastname= ' Carter '

Results:

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

•