{"id":597,"date":"2024-09-02T06:55:12","date_gmt":"2024-09-02T06:55:12","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=597"},"modified":"2025-06-03T12:29:33","modified_gmt":"2025-06-03T12:29:33","slug":"or","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/or\/","title":{"rendered":"OR"},"content":{"rendered":"\n

SQL OR Keyword<\/h2>\n\n\n\n

The OR operator is used in a WHERE clause to filter records where at least one of the given conditions is true.<\/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;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL OR with Patients Table Example<\/h2>\n\n\n\n
This query selects all patients whose gender is either ‘F'(Female)or whose last name is ‘Garcia’.<\/p>\n\n\n\n
SELECT *\nFROM Patients\nWHERE gender = 'F' OR last_name = 'Garcia';<\/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 with Appointments Table Example<\/h2>\n\n\n\n
This query selects all appointments scheduled either on ‘2023-11-15’ or with doctor_id equal to 2.<\/p>\n\n\n\n
SELECT *\nFROM Appointments\nWHERE appointment_date = '2023-11-15' OR doctor_id = 2;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL OR Labs<\/h2>\n\n\n\n