What is different between union and minus?
- 7 Answers
- 21682 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
Explain the savepoint statement.
How does cross join work in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what are the advantages a stored procedure? : Sql dba
Is time a data type in sql?
Explain cursor types?
What is the purpose of the partition table?
Is sql developer case sensitive?
Why are sql stored procedures used?
What is the process of debugging?
What is pl sql variable?
Can we delete column in sql?
What is nvarchar max in sql?
how to check server status with 'mysqladmin'? : Sql dba
How to use sql*plus built-in timers?
