Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / Q: Explain UNION,MINUS,UNION ALL, INTERSECT ?

Q: Explain UNION,MINUS,UNION ALL, INTERSECT ?
Print
Email to friend
Add comment
Views: 850
Votes: 2
Comments: 0
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.  
 
Others in this Category
document Q: Which is more faster - IN or EXISTS?
document Q: What is an execution plan? When would you use it? How would you view the execution plan?
document How to copy data from one table to another table?
document What are sp_configure commands and set commands?
document What are the properties of the Relational tables?
document How can we rewrite sub-queries into simple select statements or with joins?
document What is sub-query? Explain properties of sub-query?
document How would you handle error in SQL SERVER 2008?
document How to find tables without Indexes?
document What is Service Broker?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)