> > >

MySQL MCQs

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

SELECT * FROM teams WHERE team_won like (2, 4, 6, 8);

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

SELECT * FROM teams WHERE team_won join (2, 4, 6, 8);

SELECT * FROM teams WHERE team_won on (2, 4, 6, 8);

Answer

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

Explanation:

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

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it