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 language is oracle sql developer?

516

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

626

Is nosql faster than sql?

547

how can we optimize or increase the speed of a mysql select query? : Sql dba

515

What is sql clause?

545

What is trigger in sql? Explain

538

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

574

What is the maximum database size for sql express?

542

What are the possible values that can be stored in a boolean data field?

520

how can we know the number of days between two given dates using mysql? : Sql dba

550

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

552

What is integrity in sql?

562

what is view? : Sql dba

561

what is the difference between delete and truncate statement in sql? : Sql dba

557

How to rename a table?

562