Q. How would you select all employees from the ‘Employees’ table who are in the ‘Sales’ department OR the ‘Marketing’ department?
Solution:
The IN operator is a shorthand for multiple OR conditions. It checks if a value matches any value in a list. Option A is logically impossible (a department cannot be both ‘Sales’ and ‘Marketing’ at the same time).
Related Questions
Q. Which query would count the number of distinct cities in the ‘Customers’ table?
View SolutionQ. What is the purpose of the HAVING clause?
View SolutionQ. How can you remove a table from the database?
View Solution
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
