1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is differece between union and union all

Question Posted / shyam

Answer Posted / shyam

Union: It will combine the output of two or more queries &
it will eliminate duplicate values.

Union all:It will combine the output of two or more queries
& it will not eliminate duplicate values.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between having clause and where clause in sql server?

581

How do I create an extended event in sql server?

499

What are the advantages of stored procedure in sql server?

474

What are the joins in sql server? : sql server database administration

541

What are window functions in sql server?

518




What are the general features of sql server management studio? : sql server management studio

603

Can we insert data into view sql server?

518

What is the chart in report?

111

Explain in brief about Microsoft SQL server?

555

Explain different types of Normalization.

606

Explain identity in sql server?

569

What are the properties of the relational tables?

501

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

582

Why is normalisation important?

510

What is the difference between resultset and resultsetmetadata?

527