eDataGuru

the whole word runs on excel

This is the time for glorification!
Let us celebrate this auspicious day to begin new things in life and let knowledge take the power to get rid of the evil .

Wising you all a very Happy Dussehra!✨😊

Hello folks!👋

If you want to become a in #2021 and looking for the best online training then you have come to the right place.

Our New Batch is starting from 30th July.

ENROLL for the live Demo & interactive course!

Reach us at:
✉️: [email protected]
📞: +91 9873478473

Learn with eDataGuru

Set operators in SQL

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

UNION ALL operator is used to combine the results of two tables, and it also includes duplicate rows from the tables.

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

INTERSECT operator returns only the common records from both the queries