Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46530 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
What is mutating error in pl sql?
Why do we go for stored procedures?
What are types of exception?
Can we commit inside a trigger?
What sql does db2 use?
what are all the common sql function? : Sql dba
What are the parts of a basic sql query?
what are the different type of normalization? : Sql dba
Why is normalization important?
What is difference between cursor and trigger?
Explain aggregate functions are available there in sql?
What is an implicit commit?
How can we debug in PL/SQL?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Why function is used in sql?
