Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46336 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 process query result in pl/sql?
Can we connect to postgresql using sql developer?
Can you join views in sql?
Why is pl sql used?
What is trigger in sql? Explain
How to read xml file in oracle pl sql?
What is pl sql script?
What is fmtonly in sql?
Is sql between inclusive?
What is hibernate and its relation to sql?
What are the two types of periodical indexes?
Is json a nosql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How to check if a column is nullable before setting to nullable?
What is a schema sql?
