union is used to select distinct values from two tables where as union al

what is the difference between union and union all

Question Posted / suresh

Answer Posted / suresh

union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables

Is This Answer Correct ?

175 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is sql injection owasp?

1062

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1110

What are stored procedures used for?

1001

What is #table in sql?

1098

What are the types of functions in sql?

1019

Explain the structure of pl/sql in brief.

1095

What are different types of queries in sql?

1121

what is try_catch block in procedure

1748

What is your daily office routine?

2268

What version is sql?

1031

How do you add a column to a table?

1055

Can we rollback truncate?

998

What is column?

991

Is null operator in sql?

1038

How can use stored procedures in sql?

1137