SQL OR

The SQL OR condition is used in a SQL query to create a SQL statement where records are returned when any one of the condition met. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement.

Let's see the syntax for OR condition:

SELECT columns
FROM tables
WHERE condition 1
OR condition 2;

SQL "OR" example with SQL SELECT

SELECT * 
FROM suppliers
WHERE city = 'New York'
OR available_products >= 250;

SQL "OR" example with SQL INSERT

You can see in below example that how an SQL "OR" condition is used with SQL insert statement.

For example:

INSERT INTO suppliers(supplier_id, supplier_name)
SELECT account_no, name
FROM customers
WHERE city = 'New Delhi'
OR city = 'Ghaziabad';

SQL "OR" example with SQL UPDATE

For example:

UPDATE suppliers 
SET supplier_name = 'HP'
WHERE supplier_name = 'IBM'
OR available_product >36;

SQL "OR" example with SQL DELETE

For example:

DELETE FROM suppliers
WHERE supplier_name = 'IBM'
OR employee <=100;

Next TopicSQL with clause

<<prev next>>

SQL Tutorial

SQL Database

SQL Table

SQL Select

SQL Clause

SQL Order By

SQL Insert

SQL Update

SQL Delete

SQL Join

SQL Keys

PL/SQL Tutorial

Interview

Quiz

SQL OR

SQL "OR" example with SQL SELECT

SQL "OR" example with SQL INSERT

SQL "OR" example with SQL UPDATE

SQL "OR" example with SQL DELETE