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 the purpose of the sql select top clause?

1014

What are types of exception?

872

Which are the different types of indexes in sql?

989

what are the differences between char and nchar? : Sql dba

1054

How many parts of a pl sql block are optional?

1025

How do I partition a table in sql?

1036

How do I count duplicates in sql?

1023

How to write a query to show the details of a student from students table whose

936

how would you get the current date in mysql? : Sql dba

911

Is nosql faster than sql?

967

Can you skip header records while loading? : aql loader

968

What is the difference between cluster and non-cluster index?

1044

How to call a javascript function from pl sql?

1063

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

990

What is denormalization in a database?

988