What is the difference between UNION and UNIONALL?
Answer Posted / valarmathi
union is used to retreive the data with out duplication
union all is used to retreive the data with duplication
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What are types of scd? : sql server analysis services, ssas
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Explain linked server in sql?
Explain about sql server login?
What stored by the model?
What do you understand by recursive stored procedures?
How will you go about resolving deadlocks?
What is the cartesian product of table?
If a stored procedure is taking a table data type, how it looks?
What is difference between index and primary key?
Can you pass expressions to stored procedure parameters?
What are system databases into sql server (2005/2008)?
What is indexed view?
How many tables can be joined in SQL Server?
How to declare and use cursor variables?