English

Which set operation should be used with the SELECT statements to eliminate duplicate rows? -

Advertisements
Advertisements

Question

Which set operation should be used with the SELECT statements to eliminate duplicate rows?

Options

  • Union

  • Union all

  • Intersect

  • Minus

MCQ

Solution

Union

Explanation:

The duplicate rows are removed from the result set of the union operation.

shaalaa.com
Operations on Relations
  Is there an error in this question or solution?
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×