Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46627 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 long does it take to learn pl sql?
What is Materialized View? In What Scenario we Use Materialized View?
What is the sql query to display the current date?
What is a sql select statement?
Explain what is a field in a database and record in a database?
What are database links used for?
What is sqlite used for?
Differentiate between pl/sql and sql?
What does the file extension accdb stand for?
Which query operators in sql is used for pattern matching?
what is text? : Sql dba
Does a primary key have to be a number?
Are sql connections encrypted?
How can you save or place your msg in a table?
What is procedure and function in sql?
