Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Explain UNION,MINUS,UNION ALL, INTERSECT?



Explain UNION,MINUS,UNION ALL, INTERSECT?..

Answer / pavan_1981

UNION:set of all rows selected by both queries excluding
duplicates rows.
UNIONALL:set of all rows selected by both queries including
duplicate rows.
MINUS:set of all rows present in the first query and not
present in the second query.
INTERSECT:set of all rows commonly returned by both the
queries.

Is This Answer Correct ?    20 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,


Can we use pl sql in mysql?

0 Answers  


What packages are available to pl/sql developers?

0 Answers  


What is write ahead logging in sql server?

0 Answers  


what is union, minus and interact commands? : Sql dba

0 Answers  


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,


write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,


What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,


how many tupples can insert in 1 second in sql

1 Answers  


How to read/write files from pl/sql?

0 Answers  


what is the bond code in materialized view?

0 Answers  


Is sqlite thread safe?

0 Answers  


Categories