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
- 7qc tools
- Outer join
- Convertion of energy
- Start induction motor
- Vpn and vlan
- Inter-company journals
- System calls
- Non zero max.Code setting maxxcc=0
- Solenoid 12v valve work in DC voltage?
- Output (number of records) using joins and union
- Circuit simulation
- Order management process
- Storing of energy
- Difference between mobile app testing and mobile app native testing
- Multiple test scenarios from one test case
- Teach new employee about personal information
- Number system - single smallest possible square number
- Selenium framework architecture
- Horizontal and vertical clustering
- Adding interface to multiple inheritance in C++ language