2
Answers

How can I rewrite this SQL statement to not use OR statements in the WHERE clause and make it as efficient as possible? Its an interview question.

SELECT id, name, city
    FROM people
    WHERE title = 'Manager' OR city = 'Boston' OR HireDate > '1/25/04'

Answers (2)