What is the difference Between Union And Union All in SQL Server?

by karthikaqpt Posted: 10 years ago 1 replies

The UNION command is used to select related information from two tables, much like the JOIN command.
The UNION ALL command is similar to the UNION command, except that UNION ALL selects all values.
Any other difference Between Union And Union All in SQL Server?

#programming #difference #server #sql #union

TomWest 10 years ago

Union internally uses Distinct to sort the record for only unique records but it is slow. Union All directly show all the records never matter whether there are duplicates or not. You can read more information with the examples here UNION VS UNION ALL in Sql Server with Example :: Advance Sharp

Join the discussion

Next Topics on Trending Feed

1

What is the difference Between Union And Union All in SQL Server?

karthikaqpt • 10 years ago • 1 replies

The UNION command is used to select related information from two tables, much like the JOIN command. The UNION ALL command is similar to the UNION command, except that UNION ALL selects all values. Any other difference Between Union And Union All in SQL Server?