Multiple choice technology programming languages

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

  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. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SELECT with WHERE clause filters rows before returning them. Option C correctly uses WHERE with >= operator. Option B incorrectly uses HAVING (for aggregate filtering), and Option A has the wrong operator direction.

AI explanation

To select rows on or after a given date, you use the WHERE clause with the &gt;= (greater than or equal to) comparison operator, giving WHERE ContestDate &gt;= '05/25/2006'. &lt; would select earlier dates instead, and HAVING is used to filter aggregated groups, not individual rows, so it's the wrong clause here.

Keep practicing — related questions