> > >

MySQL MCQs

Which of the following queries will return ONE as the result?

SELECT CASE 1 WHEN 1>O THEN 'ONE‘ WHEN 2 THEN 'TWO' ELSE 'MORE' END:

SELECT CASE 1 WHEN 1 THEN 'ONE' WHEN 2 THEN 'TWO' ELSE 'MORE' END;

SELECT CASE 1 WHEN 'ONE' WHEN 2 THEN 'TWO' ELSE 'MORE' END;

None of the above.

Answer

Correct Answer: SELECT CASE 1 WHEN 1 THEN 'ONE' WHEN 2 THEN 'TWO' ELSE 'MORE' END;

Explanation:

Note: This question has more than 1 correct answers

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