> > >

SQL MCQs

What syntax would you use to write a query to select all teams that won either 2, 4, 6 or 8 games?

SELECT team_name FROM teams WHERE team_won LIKE (2, 4, 6, 8)

SELECT team_name FROM teams WHERE team_won MAP (2, 4, 6, 8)

SELECT team_name FROM teams WHERE team_won ON (2, 4, 6, 8)

SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8)

Answer

Correct Answer: SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8)

Explanation:

Note: This Question is unanswered, help us to find answer for this one

SQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it