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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Explain UNION,MINUS,UNION ALL, INTERSECT?

Question Posted / guest


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

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

how to select first 5 records from a table? : Sql dba

0 Answers  

When do we create bitmap indexes

2 Answers   CTS,

What is use of term?

0 Answers  

Define commit?

0 Answers  

How to fetch common records from two tables?

1 Answers  

How do I run a pl sql program?

0 Answers  

What do you mean by query optimization?

0 Answers  

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

What are aggregate and scalar functions?

0 Answers  

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

Should I use mbr or gpt?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories