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
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
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:
This SQL Statement with AND & OR is executed:
Here is the result.