Multiple choice technology testing

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 GROUPBY ContestDate >= '05/25/2006'

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

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

Option A correctly uses SELECT with WHERE clause and >= operator to filter rows where ContestDate is on or after May 25, 2006. Option B incorrectly uses GROUPBY (should be GROUP BY and is for aggregation, not filtering). Option C uses < instead of >=. Option D uses HAVING, which filters after GROUP BY aggregation, not for simple row filtering.

Keep practicing — related questions