C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database /
Add comment
Name:
Email:
* Comment:
(Use BBcode )


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)