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: 10

Comment

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

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Advantages Of The Oracle E-Business Suit

The Oracle EBS is a cost effective solution to all the ERP needs of your business. The following article talks about the advantages that this Oracle product has to offer. Read on to know.…

Continue

Posted by Michael Warne on April 22, 2015 at 2:00am

SAP InfiniteInsight Training

Tekslate.com is the Industry leader in providing  SAP InfiniteInsight Training across the globe. Our online training methodology focus on hands on experience of SAP InfiniteInsight

The objective of this training is to provide hands on experience and in depth understanding of the following modules of  SAP InfiniteInsight Training

 

 

Course…

Continue

Posted by Mohd Azher on April 9, 2015 at 4:19am

JIRA Training

Tekslate.com is the Industry leader in providing  JIRA Training across the globe. Our online training methodology focus on hands on experience of JIRA

The objective of this training is to provide hands on experience and in depth understanding of the following modules of  SAP InfiniteInsight Training

 

Course modules:

  • ·          Introduction to…
Continue

Posted by Mohd Azher on April 9, 2015 at 4:15am

DataStage Training

Tekslate.com is the Industry leader in providing as DataStage Training  across the globe. Our online training methodology focus on hands on experience of Datastage

The objective of this training is to provide hands on experience and in depth understanding of the following modules of  DataStage

Course…

Continue

Posted by Mohd Azher on April 3, 2015 at 6:45am

© 2015   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service