Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 45859 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / soubhagya
Union:
It retrieves only distinct records.
Union all:
This retrieves duplicate records too.
but in performance issue
unioun all is better becoz it doesnot sort, filter the
record so its faster.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to test for null values?
what are tables and fields? : Sql dba
What schema means?
Is sql considered coding?
what is the difference between delete and truncate commands? : Sql dba
Is a view faster than a stored procedure?
What is a record in a database?
What version is sql?
Who developed sql?
How many subqueries can be nested in a statement?
How many types of index are there?
what are the different functions in sorting an array? : Sql dba
What is procedure and function?
What is primary key secondary key alternate key candidate key?
differentiate between float and double. : Sql dba
