UNION: combine distinct values between two tables UNION ALL : combine all

what is differece between union and union all

Question Posted / ramesh raja

Answer Posted / ramesh raja

UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values
between the two tables

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is inner join? Explain with an example?

1286

How will you find out if there are expensive SQL statements running or not?

1071

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

Explain what are partitioned views and distributed partitioned views?

1017

What is a fan-out query in SQL Azure?

123

Do you know the cursor optimization tips?

1039

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1249

What do you understand by physical_only option in dbcc checkdb?

1024

What command would you use to create an index?

1108

What are temporal tables in sql server 2016?

930

What is the web service used for reporting services?

126

What is a result set object returned by mssql_query()?

1230

What are commonly used odbc functions in php?

1059

How to insert multiple rows with a subquery?

1190

How to start sql server browser service?

1183