This is a discussion on What is the difference between UNION and UNIONALL in SQL Server? within the Database Support forums, part of the Web Development category; What is the difference between UNION and UNIONALL in SQL Server?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| What is the difference between UNION and UNIONALL in SQL Server? |
|
#2
| |||
| |||
| UNION: Eliminates duplicates UNION ALL: Retains duplicates Both these are used to combine the results of different SELECT statements. |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Make out of Structure and Union | velhari | C and C++ Programming | 2 | 04-03-2008 02:55 AM |
| Union and Union All | itbarota | Database Support | 2 | 03-03-2008 12:41 AM |
| UNION ALL faster than a UNION? | vadivelanvaidyanathan | Database Support | 4 | 08-18-2007 01:04 AM |
| what is the UNION in c++? with Example | sundarraja | C and C++ Programming | 1 | 07-20-2007 06:44 AM |
| What's the difference between a structure and a union | prasath | C and C++ Programming | 1 | 07-18-2007 04:14 AM |
Our Partners |