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

The UNION ALL has a higher precedence than UNION DISTINCT.

Answer & Solution
Correct Answer: Option B
This question asks about the order in which MySQL processes UNION ALL and UNION DISTINCT operations.

UNION ALL combines the results of two or more queries, including all duplicate rows.

UNION DISTINCT also combines results, but it removes duplicate rows.

The question states that UNION ALL has a higher precedence than UNION DISTINCT. This means that UNION ALL is processed before UNION DISTINCT.

The correct answer is False. UNION ALL and UNION DISTINCT have the same precedence.

In simple terms, MySQL doesn't prioritize one over the other. They are treated equally.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.