The statement SELECT YearWon,Title,ProductionCo FROM tblMovies WHERE YearWon = 2006 selects all of the fields from records for the year 2006 and later.

Name: The statement SELECT YearWon,Title,ProductionCo FROM tblMovies WHERE YearWon >= 2006 selects all of the fields from records for the year 2006 and later.
Brand: Quizplus
Rating: 4.9 (32 reviews)

Question

The statement SELECT YearWon,Title,ProductionCo FROM tblMovies WHERE YearWon >= 2006 selects all of the fields from records for the year 2006 and later.

Quizplus · Accepted Answer

The WHERE clause specifies that only records with a YearWon value greater than or equal to 2006 will be selected, not all records from 2006 and later.

The Statement SELECT YearWon,Title,ProductionCo FROM TblMovies WHERE YearWon >= 2006