SQL AND & OR


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

SQL > SQL Advanced > SQL AND & OR


What is SQL AND & OR

The SQL AND & OR operators support compound conditions in the SQL WHERE clause.

Why Use SQL AND & OR

Use SQL AND & OR operators in case when a WHERE clause requires multiple conditions. For example, we may want to select a list of CUSTOMERS whose accounts are on credit hold and whole credit balance exceeds the credit limit. Such a statement may look like this:

SELECT customer_nbr, customer_name, credit_limit_amt, credit_balance_amt
FROM CUSTOMER
WHERE credit_hold_ind = 'Y'
AND credit_balance_amt > credit_limit_amt
 

How To Use SQL AND & OR

SQL AND & OR are placed between conditions to create compound conditions. Parenthesis can be used to group conditions.

SQL AND & OR Syntax

 
SELECT <column_list>
FROM <table_name>
WHERE <condition_1>
AND|OR <condition_2>
 

SQL AND & OR Example

The following example selects a list of rows from the branch table that have an employee_count less than 4 or greater than 6.

Here are the contents of the table:

Table: BRANCH
branch_nbrbranch_nameregion_nbremployee_count
108New York10010
110Boston1006
212Chicago2005
404San Diego4006
415San Jose4003

This SQL Statement with AND & OR is executed:

 
SELECT branch_nbr, branch_name, employee_count
FROM branch
WHERE employee_count < 4
OR employee_count > 6
 

Here is the result.

branch_nbrbranch_nameemployee_count
108New York10
415San Jose3

Copyright© 1999-2015, First Place Software, Inc.