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

Can I learn sql in a week?

1083

What is data control language (dcl)?

1147

What is the use of index in sql?

1021

Do stored procedures prevent sql injection?

972

What is the benefit of foreign key?

1023

What is the difference between inner join and natural join?

1013

What are the operators in sql?

1035

What is the difference between function, procedure and package in pl/sql?

1269

explain normalization concept? : Sql dba

1053

What is the difference between the conventional and direct path loads? : aql loader

1405

What is lookup table in sql?

1054

how is myisam table stored? : Sql dba

1062

What is difference between pl and sql?

1069

What are the two types of exceptions in pl/sql?

1054

What is Collation Sensitivity ? What are the various type ?

956