English

Which set operation is used to return the common row from relation? -

Advertisements
Advertisements

Question

Which set operation is used to return the common row from relation?

Options

  • Union

  • Union all

  • Intersect

  • Minus

MCQ

Solution

Intersect

Explanation:

The intersect operation joins two SELECT statements and returns the rows that are common to both.

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

Englishहिंदीमराठी


      Forgot password?
Use app×