Union will return only distinct values from two tables. Union all will ret

what is the difference between union and union all

Question Posted / anjani kumar

Answer Posted / anjani kumar

Union will return only distinct values from two tables.
Union all will return duplicate values from the two tables

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are rollup and cube in t-sql? : Transact sql

657

Why should I use postgresql?

561

Why do we need view in sql?

547

What is the maximum size of sqlite database?

546

explain the difference between bool, tinyint and bit. : Sql dba

520

what is single byte over head in oracle..?

1865

What are secondary keys?

557

Is it important to partition hard disk?

531

what are the advantages a stored procedure? : Sql dba

543

What does t sql mean?

532

What is the difference between left join and right join?

500

Can we rename a column in the output of sql query?

538

what tools available for managing mysql server? : Sql dba

529

Can we call a function containing dml statements in a select query?

540

what is data manipulation language? : Sql dba

527