> > >

MySQL MCQs

Which of the following is the correct way to retrieve rows with no duplicates?

SELECT * FROM TableA WHERE ColumnX IS DISTINCT;

SELECT UNIQUE * FROM TableA WHERE ColumnX="SomeValue";

SELECT DISTINCT * FROM TableA WHERE ColumnX="SomeValue";

SELECT * FROM TableA WHERE ColumnX=UNIQUE("SomeValue");

SELECT * FROM TableA WHERE ColumnX IS UNIQUE;

Answer

Correct Answer: SELECT DISTINCT * FROM TableA WHERE ColumnX="SomeValue";

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