SQL AND OR - SQL Tutorial

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_nbr branch_name region_nbr employee_count

108 New York 100 10

110 Boston 100 6

212 Chicago 200 5

404 San Diego 400 6

415 San Jose 400 3

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_nbr branch_name employee_count

108 New York 10

415 San Jose 3