---
title: "What is UNION,UNION ALL?"  
description: "What is UNION,UNION ALL?"  
author: "Varun Agrawal"  
published: 2011-03-28  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/614/what-is-union-union-all  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# What is UNION,UNION ALL?

UNION : eliminates duplicates \
UNION ALL: retains duplicates \
Both these are used to combine the results of different SELECT statements.

## Answers

### Answer by Varun Agrawal

UNION : eliminates duplicates \
UNION ALL: retains duplicates \
Both these are used to combine the results of different SELECT statements.


---

Original Source: https://www.mindstick.com/interview/614/what-is-union-union-all

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.