Home > DeveloperSection > Interviews > What is difference between Union, minus and Interact commands?
 Ask Question

What is difference between Union, minus and Interact commands?

Total Post:55

Points:275

C#
 174  View(s)
Ratings:
Rate this:
  1. What is difference between Union, minus and Interact commands?

    The UNION operator is used to combining the results of two tables, and it eliminates duplicate rows from the tables.

    The MINUS operator is used to return rows from the first query but not from the second query. Matching records of the first and second query and other rows from the first query will be displayed as a result set.

    INTERSECT operator is used to returning rows returned by both the queries.

Answer

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x