ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which Keyword is used to remove duplicate rows in the result set?

Answer & Solution
Correct Answer: Option A
This question asks about how to get rid of repeated rows in a table's results.
Imagine you have a list of fruits, and some fruits appear multiple times.
You want to see only one of each fruit, not all the repetitions.
That's what the DISTINCT keyword does.
So the answer is Option C: DISTINCT.
Option A: DISTINCTS is incorrect because it is not a valid keyword.
Option B: MODIFY is used to change the structure of a table, not to remove duplicates.
Option D: All of the mentioned is incorrect because only DISTINCT is the correct keyword.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.