what is the difference between union and union all
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
What is hibernate and its relation to sql?
Which is faster joins or subqueries?
What are the indexing methods?
What is offset in sql query?
Explain unique key in sql.
What is memory optimized?
What is sql scripting?
What is on delete set null?
what is the difference between a having clause and a where clause? : Sql dba
What do you mean by query optimization?
What do you understand by pl/sql records?
what is a relationship and what are they? : Sql dba
How to look at the current sql*plus system settings?
What is normalization in a database?
What is query syntax?