Explain UNION, MINUS, UNION ALL and INTERSECT
Answer posted by Scott on 2005-05-25 18:32:51: UNION - the values of the first query are returned with the values of the second query eliminating duplicates.
MINUS - the values of the first query are returned with duplicates values of the second query removed from the first query.
UNION ALL - the values of both queries are returned including all duplicates
INTERSECT - only the duplicate values are returned from both queries.
Editorial / Best Answerrampratap409
UNION: Take the common record once( No Duplicate)
UNION ALL : Takes Duplicates also
Minus: Result of first query - result of second query
select * from emp where rownum<=9;
select * from emp where rownum<9;
this will display 9th row of emp
Intersect: common result of both query
- Why neutral is not used in delta circuit?
- Entropy and enthalpy
- Remove duplicate stage
- Dns server faults
- Dns query
- Save button test case
- Form of fact and dimension table
- Why star delta starter prefer to d.O.L starter for large motors?
- 40 ibm Oracle DBA interview questions
- Register a component in multiple locations
- Adding interface to multiple inheritance in C++ language
- Object and relational view
- Copy data from pds to vsam
- Diplay records using rownum, minus & union
- Etl testing insurance project
- Oracle DBA upgrade concepts
- A good tester vs. Good leader
- Manual testing backend process
- Real time claims processing
- Game of jack straws