Multiple choice technology databases

Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 2006?

  1. SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

  2. SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

  3. SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

  4. SELECT * FROM Contest IN ContestDate < '05/25/2006'
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SELECT * FROM Contest WHERE ContestDate >= '05/25/2006' is correct. The WHERE clause filters rows based on the date condition, and >= selects dates on or after May 25, 2006. Option C uses < (wrong direction), B uses HAVING (for aggregated data), and D has invalid syntax.

Keep practicing — related questions