Oracle Community

The social network for Oracle people

Combining AND & OR

You can also combine AND and OR (use parenthesis to form complex expressions).

Now we want to select only the persons with the last name equal to "Svendson" AND the first name equal to "Tove" OR to "Ola":

We use the following SELECT statement:

SELECT * FROM Persons WHERE
LastName='Svendson'
AND (FirstName='Tove' OR FirstName='Ola')

Views: 6

Comment

You need to be a member of Oracle Community to add comments!

Join Oracle Community

© 2013   Created by Eddie Awad.

Badges  |  Report an Issue  |  Terms of Service