Union will return only distinct values from two tables. Union all will ret

what is the difference between union and union all

Question Posted / anjani kumar

Answer Posted / anjani kumar

Union will return only distinct values from two tables.
Union all will return duplicate values from the two tables

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of sql? Explain

1107

What are aggregate functions in sql?

1161

What are the most important ddl statements in sql?

1116

What is difference between my sql and sql?

1075

What is procedure and function in sql?

1001

How to connect a sql*plus session to an oracle server?

1128

What is sqlexception in java?

993

What is the least restrictive isolation level? : Transact sql

1069

what is a view? : Sql dba

1094

what are date and time functions in mysql? : Sql dba

979

What is not in sql?

950

what does it mean to have quoted_identifier on? : Sql dba

1146

Which join condition can be specified using on clause?

952

What is difference between function and trigger?

1052

how to get a list of indexes of an existing table? : Sql dba

960