(Scroll to see more)
- SQL ALIASES
- SQL ALTER TABLE
- SQL AND
- SQL AND & OR
- SQL AVG
- SQL BETWEEN
- SQL COUNT
- SQL CREATE TABLE
- SQL CREATE TABLE AS
- SQL DATA TYPES
- SQL DELETE
- SQL DISTINCT
- SQL DROP TABLE
- SQL EXISTS
- SQL FROM
- SQL GLOBAL TEMP
- SQL GROUP BY
- SQL HAVING
- SQL IN
- SQL INSERT
- SQL INTERSECT
- SQL IS NOT NULL
- SQL IS NULL
- SQL JOIN
- SQL LIKE
- SQL LOCAL TEMP
- SQL MAX
- SQL MIN
- SQL MINUS
- SQL NOT
- SQL OR
- SQL ORDER BY
- SQL SELECT
- SQL SUM
- SQL UNION
- SQL UNION ALL
- SQL UPDATE
- SQL VIEW
- SQL WHERE
SQL: OR Condition
Learn how to use the SQL OR condition with syntax and examples.
The SQL OR Condition is used to test multiple conditions, where the records are returned when any one of the conditions are met. It can be used in a SELECT, INSERT, UPDATE, or DELETE statement.
The syntax for the SQL OR Condition is:
WHERE condition1 OR condition2 ... OR condition_n;
Parameters or Arguments
condition1, condition2, condition_n are any of the conditions that must be met for the records to be selected.
- The SQL OR condition allows you to test 2 or more conditions.
- The SQL OR condition requires that any of the conditions (ie: condition1, condition2, condition_n) be must be met for the record to be included in the result set.
Example - With SELECT Statement
The first SQL OR condition example that we'll take a look at involves a SQL SELECT statement with 2 conditions:
SELECT * FROM suppliers WHERE city = 'New York' OR available_products >= 250;
This SQL OR condition example would return all suppliers that reside in either New York or have available_products greater than or equal to 250. Because the * is used in the SELECT statement, all fields from the suppliers table would appear in the result set.
Example - With SELECT Statement (3 conditions)
The next SQL OR example takes a look at a SQL SELECT statement with 3 conditions. If any of these conditions is met, the record will be included in the result set.
SELECT supplier_id FROM suppliers WHERE supplier_name = 'IBM' OR city = 'New York' OR offices > 5;
This SQL OR condition example would return all supplier_id values where the supplier's name is either IBM, city is New York, or offices is greater than 5.
Example - With INSERT Statement
The SQL OR condition can be used in the SQL INSERT statement.
INSERT INTO suppliers (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE city = 'New York' OR city = 'Newark';
This SQL OR condition example would insert into the suppliers table, all account_no and name records from the customers table that reside in either New York or Newark.
Example - With UPDATE Statement
The SQL OR condition can be used in the SQL UPDATE statement.
UPDATE suppliers SET supplier_name = 'HP' WHERE supplier_name = 'IBM' OR available_products > 36;
This SQL OR condition example would update all supplier_name values in the suppliers table to HP where the supplier_name was IBM or its available_products was greater than 36.
Example - With DELETE Statement
The SQL OR condition can be used in the SQL DELETE statement.
DELETE FROM suppliers WHERE supplier_name = 'IBM' OR employees <= 100;
This SQL OR condition example would delete all suppliers from the suppliers table whose supplier_name was IBM or its employees was less than or equal to 100.