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 unique key constraint? : Sql dba

656

Show the cursor attributes of pl/sql.

701

Is sql a backend language?

741

Can one improve the performance of sql*loader? : aql loader

674

How does sql store data?

568

What is a composite primary key?

681

What is the purpose of cursors in pl/sql?

715

Explain the order of sql statement execution?

712

Can 2 queries be executed simultaneously in a distributed database system?

747

What is an implicit commit?

646

What are the different ddl commands in sql?

652

what is rdbms? : Sql dba

667

which operator is used in query for pattern matching? : Sql dba

650

Why do we use sqlite?

612

what are the disadvantages of mysql? : Sql dba

657