1)Union is used to select distinct values from two tables where as union a

what is differece between union and union all

Question Posted / dinesh waitage

6 Answers
10368 Views
I also Faced
E-Mail Answers

Answer Posted / dinesh waitage

1)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.

2)UNION - returns on Distinct rows/Slower in performance
UNION ALL.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different types of collation sensitivity?

1025

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1230

Can you explain important index characteristics?

1031

what is denormalization? : Sql server database administration

973

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1121

What is Sqlpaging in SqlServer 2005 ?

1115

Explain ranking functions?

1098

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1104

Mention what are the core components of ssrs?

330

What is the difference between row_number and dense_rank?

936

Explain the disadvantages of cursors?

1208

What is your recommendation for a query running very slow? : sql server database administration

1113

Explain the concept of view and Types of views in SQL server?

1035

What is Transparent Data Encryption?

1061

How to create new table with "create table" statements?

1193