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

I need a function for a train ticket reservation please answer it thanks in advance

571

What is function and procedure in pl sql?

528

what is a database? : Sql dba

612

What is rank () in sql?

542

What is the difference between cross join and natural join?

577

Is keyword pl sql?

566

What are types of exception?

544

what is foreign key? : Sql dba

591

What is a scalar value in sql?

596

Is id a reserved word in sql?

670

what are all the common sql function? : Sql dba

593

Why do we use triggers?

528

How to revise and re-run the last sql command?

656

What are types of joins?

543

Which language is used in sql?

536