1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

What's the difference between 'union' and 'union all' ?

Question Posted / hemant gupta


What's the difference between 'union' and 'union all' ?..

Answer / Sravan Kumar Gautam

UNION removes duplicate rows from the result set, while UNION ALL keeps all the rows. UNION is used when you want a unique list of records combined from multiple queries, whereas UNION ALL is used to combine all records regardless of duplicates.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is cursor and where do you use them?

2 Answers   eBay,

What are the Different Types of Joins and How do They Work?

1 Answers  

What is end users in dbms?

1 Answers  

What are views in dbms?

1 Answers  

What is data sublanguage?

1 Answers  

Is google a database?

1 Answers  

How to prevent concurrent access to my data?

1 Answers   HCL,

Mention a query to calculate the even and odd records from a table

1 Answers  

What are the two major subsystems of system r?

1 Answers  

What is the easiest database to learn?

1 Answers  

What is a relation schema?

1 Answers  

Why is data modelling important?

1 Answers  

For more Database Management Interview Questions Click Here
Categories