What the difference between UNION and UNIONALL?
- 1 Answers
- 1117 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / Neha Gautam
{"union": {"description": "The UNION operator combines the result sets of two or more SELECT statements and eliminates duplicate rows based on a common column."},"union all": {"description": "The UNION ALL operator also combines the result sets of two or more SELECT statements but does not eliminate any duplicate rows."}}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a coalesce function?
What is clustered index
Why and when do stored procedure recompile?
What are the different SQL Server Versions you have worked on?
What is normalization and what are the advantages of it?
How efficient you are in oracle and SQL server?
Is it possible to have clustered index on separate drive from original table location?
What is sql or structured query language?
What is sql server query analyzer?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is the difference between for xml raw and for xml auto?
How can we solve concurrency problems?
How do I create a trace in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can we shrink data file in sql server?
