Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 23745 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / varma
union:
Union combines result set of two select statements
into one result set and from the result it eliminates
duplicate rows.
Minus:
Minus takes the result set of one select statement
and removes those rows that are also returned by another
select statement.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are different types of indexes?
How to disable a trigger name update_salary?
What are the benefits of triggers?
what is a materialized view? : Sql dba
What is the difference between the conventional and direct path loader? : aql loader
what is view? : Sql dba
What is the difference between function, procedure and package in pl/sql?
What is the difference between Union and Union all. Which is faster.
what are the advantages of using stored procedures? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
What is constant in pl sql?
what is a field in a database ? : Sql dba
what are the nonstandard string types? : Sql dba
How to assign sql query results to pl sql variables?
What is an example of translating a date into julian format?
