SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

June 9, 2012 by Joey Blue Leave a Comment

SQL AND OR

The SQL AND OR is used when filtering with the SQL Where clause.  More specifically, we are talking about the “AND” and the “OR” clauses.

Let’s start by looking at a basic SQL statement:

select * from customer 

The customer table has the following records:

SNAGHTML125a449e

Now if we were to filter to just the “Dell” records, we would use the following query:

select * 
from customer 
where customer_company = 'Dell'; 

But, I want to get the “Dell” records and the “HP” records.  To do that we would use the following query:

select * 
from customer 
where customer_company = 'Dell' 
 or customer_company='HP'; 

And we get the following results:

SNAGHTML125d1592

Now, you are probably asking, “You said we want Dell AND HP records, why did we use the OR clause?”

It can be a little confusing, but here is how I think of it.

In the case where we want the company of Dell and HP, we are actually saying we want all of the records where the customer_company is Dell or the customer company is HP.

There is a never a case where the customer_company is both Dell and HP.

So let’s look at an example where we use the AND statement.

If, I wanted to get all of the Dell customers that have a name of Bill, I would use the following query:

select * 
from customer 
where customer_company = 'Dell' 
 and customer_name='Bill'; 

In this case, I am actually looking for records where both criteria is met.  Here is the result:

SNAGHTML1261c7c1

Those are the basics of using the SQL AND and OR clauses.

Please leave and questions or comments below and let me know if you want me to talk about any other topics.

Related

Filed Under: SQL Training Tagged With: Beginning SQL, SQL AND OR, SQL Where

Leave a Question, Comment, or Reply. All are welcome! Cancel reply

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com