{"id":151,"date":"2024-08-21T05:41:39","date_gmt":"2024-08-21T05:41:39","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=151"},"modified":"2025-05-09T08:52:59","modified_gmt":"2025-05-09T08:52:59","slug":"sql-or","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-or\/","title":{"rendered":"SQL Or"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n


<\/p>\n\n\n\n

SQL Or Syntax<\/h2>\n\n\n\n
SELECT column1, column2, ...\nFROM table_name\nWHERE condition1 OR condition2 OR ...;<\/pre><\/div>\n\n\n\n

<\/p>\n\n\n\n
SQL Or Example<\/h2>\n\n\n\n
SQL Or Basic OR Usage Example<\/h3>\n\n\n\n
This query retrieves the first_name, last_name, and specialty columns from the DOCTORS table for doctors whose specialty is either ‘Cardiology’ or ‘Neurology’.<\/p>\n\n\n\n
SELECT first_name, last_name, specialty\nFROM Doctors\nWHERE specialty = 'Cardiology' OR specialty = 'Neurology';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n
SQL Or Using OR with Multiple conditions Example<\/h3>\n\n\n\n
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).<\/p>\n\n\n\n
SELECT first_name, last_name, dob, gender\nFROM Patients\nWHERE gender = 'F' OR dob < '1985-01-01';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Or Combining OR with AND<\/h3>\n\n\n\n
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’).<\/p>\n\n\n\n
SELECT first_name, last_name, contact_number, dob\nFROM Patients\nWHERE gender = 'M' AND (contact_number IS NOT NULL OR dob > '1990-01-01');<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Or Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Or Labs<\/h2>\n\n\n\n