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

How to use transactions efficiently : transact sql

555

What are the different ddl commands in sql?

586

What are the commands used in sql?

540

how to enter numeric values as hex numbers? : Sql dba

580

Does google use sql?

526

How do I order by ascending in sql?

546

What will you get by the cursor attribute sql%notfound?

601

How do you modify a table in sql?

583

What is embedded sql what are its advantages?

514

What is user in sql?

593

What is data control language?

539

How to get help at the sql prompt?

653

Can you have more than one key in a database?

525

What is information schema in sql?

588

What is left join in postgresql?

547