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 / ranjay kumar singh

Answer Posted / ranjay kumar singh

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 ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

List the different type of joins?

1061

What are triggers in sql?

1021

Can ddl statements be used in pl/sql?

1145

What is schema in sql?

950

What is audit logout in sql profiler?

1026

What is memory optimized table?

1047

What is difference between table and view?

1057

Which language is used in sql?

1060

What are predefined functions in sql?

1045

What is ttitle and btitle?

1065

Can a view be mutating? If yes, then how?

1028

what is difference between delete and truncate commands? : Sql dba

1134

What is a primary key called that is made up of more than one field?

1351

What is cross join sql?

918

explain commit and rollback in mysql : sql dba

1020