Set Operators in SQL

Set Operators in SQL

Set Operators in SQL Server Part - 10

In this post I will explain about Set Operators in SQL Server, although this part is quite short. So let’s start.

Set Operators in SQL

Set Operators in SQL: There are 4 types of set operators in SQL –

  1. Union – Distinct records in ascending order
  2. Union All – Includes Duplicate values
  3. Intersect – Common and distinct records in ascending order
  4. Except – Minus and distinct records in ascending order

1. UNION

When we want to retrieve the same information from all the tables, then we use the union. If we use union then it will return the distinct records and in this case no. of fields and order should be the same in all the tables and data type must be compatible.

Syntax –

Set Operators in SQL Server Part - 10 UNION

2. UNION ALL

When we want to retrieve the same information from all the tables, then we use Union All. If we use union all then it will return all records and in this case no. of fields and order should be the same in all the tables and data type must be compatible.

Syntax:

Set Operators in SQL Server Part - 10 UNION ALL

3. INTERSECT

The SQL INTERSECT set operator or clause is used to returns rows only from the first SELECT statement that is identical to a row in the second SELECT statement when combining two SELECT statements. INTERSECT returns the common rows only by using two SELECT statements. Just as with the UNION operator, the same rules apply when using the INTERSECT operator.

Syntax:

Set Operators in SQL Server Part - 10 INTERSECT

Result:

Set Operators in SQL Server Part - 10 INTERSECT RESULT

4. EXCEPT

The SQL EXCEPT set operator or clause is used to returns rows from the first SELECT statement that is not returned by the second SELECT statement by combining two SELECT statements. EXCEPT returns the rows, which are not found in the second SELECT statement. Just like the UNION operator, the same rules apply when using the EXCEPT set operator.

Syntax:

Set Operators in SQL Server Part - 10 EXCEPT

Result:

Set Operators in SQL Server Part - 10 EXCEPT RESULT

Assuming this tutorial post on Set Operators in SQL has well-acquainted aspiring to the complete requirement.

Also requesting, if you have any ideas or suggestions for me or you need some important blogs/Videos or guidelines related to SQL Server, Excel, WordPress, SEO, Website technologies then please feel free to write me on below comment section or you can go through the Contact Page. I will definitely come back to you with your desired requirements.

Disclaimer

We are approaching to make the information available on this website as authentic as possible. We are not responsible for any error that may have crept in the result of typos being published on this website and for any loss to anyone or anything caused by any short comes, defect or inaccuracy of the information on this website. The tutorial or posts published in this website is only for the immediate information to learners and does not to be constituted to be a legal document.

Hope this tutorial post was helpful for you and you liked very well, I am happy to serve you better. If you liked really this tutorial post, please don’t forget to share on social media like – Facebook, Whatsapp, LinkedIn, Twitter, Instagram, etc.

Leave a Reply