ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what is differece between union and union all
 Question Submitted By :: Nidhinac
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is differece between union and union all
Answer
# 1
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)
 
Is This Answer Correct ?    6 Yes 0 No
Samy
 
  Re: what is differece between union and union all
Answer
# 2
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.
 
Is This Answer Correct ?    3 Yes 0 No
Shyam
 
 
 
  Re: what is differece between union and union all
Answer
# 3
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
 
Is This Answer Correct ?    0 Yes 0 No
Dinesh Sharma
 
  Re: what is differece between union and union all
Answer
# 4
UNION: combine distinct values between two tables
UNION ALL : combine all values and also duplicates values 
between the two tables
 
Is This Answer Correct ?    2 Yes 0 No
Ramesh Raja
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Why we need a group by clause?  3
Can we call SP inside a query? Wipro4
how to delete duplicate rows from table in sql server HCL8
What is a view?  4
Explain the new features of SQL server 2000?  1
What is a Lock and let me know Different types of locks?  1
how to find nth highest salary NexGen30
select top 5 * from emp order by newid() my question is , how this query get executed?  4
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
what operator performs pattern matching?  1
What are the steps you will take to improve performance of a poor performing query? HCL1
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??  1
could u plz explain about joins and views?  2
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?  2
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode? HCL2
what is replication? where do u use Go Keyword? Satyam1
Can you have a nested transaction? HCL3
plz send every query in sql server2000 Infosys1
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE IBM1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com