🎴 Flashcard Mode

SQL Fundamentals

Card1 / 20

Mastered0

Review0

QuestionClick to flip

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

AnswerClick to flip back

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

💡 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.

Change Mode