In SQL, which operator is used to combine multiple conditions with an OR condition?OptionsANDORXORNOT

Answer

In SQL, the operator used to combine multiple conditions with an OR condition is OR.

The OR operator allows you to specify that at least one of the conditions must be true for the overall expression to be true. For example:

SELECT * FROM Employees
WHERE Department = 'Sales' OR Department = 'Marketing';

In this query, it will return employees who are either in the Sales department or the Marketing department. This flexibility is essential for building complex queries where multiple possible conditions exist.

To summarize, the correct option for combining multiple conditions with an OR condition in SQL is OR.