SQL Or

The SQL Or clause is used to filter records where at least one of the conditions specified is true. Unlike the AND clause, which requires all conditions to be met, the OR clause allows for flexibility by including records that meet any of the given conditions.

SQL Or Syntax

SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2 OR ...;

SELECT column1, column2, ...

FROM table_name

WHERE condition1 OR condition2 OR ...;

SQL Or Example

SQL Or Basic OR Usage Example

This query retrieves the first_name, last_name, and specialty columns from the DOCTORS table for doctors whose specialty is either ‘Cardiology’ or ‘Neurology’.

SELECT first_name, last_name, specialty
FROM Doctors
WHERE specialty = 'Cardiology' OR specialty = 'Neurology';

SELECT first_name, last_name, specialty

FROM Doctors

WHERE specialty = 'Cardiology' OR specialty = 'Neurology';

SQL Or Using OR with Multiple conditions Example

This query retrieves the first_name, last_name, dob (date of birth), and gender columns from the PATIENTS table. It includes all female patients (gender = ‘F’) and patients who were born before January 1, 1985 (dob < ‘1985-01-01).

SELECT first_name, last_name, dob, gender
FROM Patients
WHERE gender = 'F' OR dob < '1985-01-01';

SELECT first_name, last_name, dob, gender

FROM Patients

WHERE gender = 'F' OR dob < '1985-01-01';

SQL Or Combining OR with AND

This query selects the first_name, last_name, contact_number, and dob (date of birth) columns from the PATIENTS table. It filters the results based on gender (gender = ‘M’), contact_number is not NULL, and dob (date of birth) must be later than January 1, 1990 (dob > ‘1990-01-01’).

SELECT first_name, last_name, contact_number, dob
FROM Patients
WHERE gender = 'M' AND (contact_number IS NOT NULL OR dob > '1990-01-01');

SELECT first_name, last_name, contact_number, dob

FROM Patients

WHERE gender = 'M' AND (contact_number IS NOT NULL OR dob > '1990-01-01');

SQL Or Visual Diagram

SQL Or Labs