Answer / samy

Union:
combine two tables and common values to be retrieved no
duplicate values

Union All:

All the values to be retrieved when combine two table.
(duplicate values)

Answer / 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.

Answer / ramesh raja

UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values
between the two tables

Answer / dinesh sharma

Union:Only Select Distinct Value
Union All:Select All Values Using Duplicate
All Selected Columns Must Have Same DataType
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth

Answer / shabanafazal

in case of 'union' the data of two tables are combined
together with no repetition where as incase of 'union all'
repetition of data is done e.g in table 'A' we have name
saad three times and in 'B' table name 'ssad' is present
one time then in case of 'union' 'saad' is appeard once
(when union of table 'A' and 'B' is done). where as in case
of 'union all' the name 'saad' will repeated four times.

Answer / 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.

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

What the different components of Replication and what is their use?

0 Answers  

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

How many types of Outer Joins?What are they?

1 Answers  

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

What is optimization and its types?

0 Answers  

What is difference between rownum and row_number?

0 Answers  

Do you know what are the ways available in sql server to execute sql statements?

0 Answers