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:

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