Justin N

Justin N

  • NA
  • 19
  • 0

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.

Feb 11 2011 6:13 PM
SELECT id, name, city
    FROM people
    WHERE title = 'Manager' OR city = 'Boston' OR HireDate > '1/25/04'

Answers (2)