C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database /
Email to friend
* Your name:
* Your email:
* Friend's email:
Comment:


Q: Explain UNION,MINUS,UNION ALL, INTERSECT ?
A: INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.  
 


RSS
Powered by KBPublisher (Knowledge base software)