Read Catalogue
- SQL Server Functions---Union and UNION ALL differences
Back to top SQL Server functions---Union and UNION ALL differences
If we need to display the results of the two SELECT statements as a whole, we need to use the union or UNION ALL keyword. Union (or union) is the function of merging multiple results together to display them.
the difference between Union and UNION ALL: Union automatically compresses duplicate results in multiple result sets, and union ALL displays all results, whether duplicates or not.
Union: Set operation on two result sets, excluding duplicate rows, and sorting the default rules;
The Union will filter out duplicate records after the table link is made, so the resulting set of results will be sorted after the table is connected, the duplicate records are deleted and the results returned. Most of the actual applications do not produce duplicate records, most commonly, the process table and the History table Union
If you think reading this blog gives you something to gain, you might want to click " recommend " in the lower right corner.
If you want to find my new blog more easily, click on " Follow me "
If you want to give me more encouragement, you may wish to click on the right, " enjoy your stay"
Blog is his own summary of the results of learning, learning to summarize the knowledge-"analysis of the problem-" to solve the problem.
Where the views/descriptions in the text are incorrect, please correct them.
Thank you for your reading, if you are interested in the content of my blog, please continue to follow my following blog, I am yxtic.
SQL Server functions?