What is different between union and minus?
- 7 Answers
- 21093 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / pravin
Union combines the two table records, its eliminates
the duplicate records. while minus shows only those rows
which are not dulicated of table first in query.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What can sql server reporting services do?
What is a recursive stored procedure?
What are views in sql?
which types of join is used in sql widely? : Sql dba
Is sql developer case sensitive?
What is pl sql record in oracle?
Is natural join same as inner join?
what is text? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is PL/SQL Records?
What is mdf ldf and ndf?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Why stored procedure is better than query?
What are the different datatypes available in PL/SQL?
How do sql triggers work?
