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 / pavan_1981

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is sql*loader direct path so fast?

1104

What is view explain with example?

932

Is and as keyword in pl sql?

961

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1064

Define union, minus, union all, intersect ?

1007

What are different types of keys?

1106

what is sql profiler? : Sql dba

1048

What is sql keyword?

1004

What does select top 1 do in sql?

1098

What is database white box testing and black box testing?

1111

Is pl sql still used?

977

What is sql in oracle?

1062

Is it possible to create startup or shutdown trigger for on-schema?

1029

What is a common use of group by in sql?

1051

Is t sql a programming language?

1069