Explain what is the difference between union and union all?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,


What is difference between joins and subqueries?

0 Answers  


What are the essential components of sql server service broker?

0 Answers  


How many database files are there in sql server 2000?what are they?

0 Answers  


select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,






In which year relase the 7.0& 2000 & 2005?

1 Answers  


Can we add a cpu to sql server?

0 Answers  


What are unicode character string data types in ms sql server?

0 Answers  


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  


What is a result set object returned by odbc_exec()?

0 Answers  


How do I install only the client tools of sql server 2000?

0 Answers  


explain the storage models of olap? : Sql server database administration

0 Answers  


Categories