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?

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

What is auto increment?

936


What is gpt format?

895


How does cross join work?

877


Why do we use sql constraints?

1124


What program will open a mdb file?

915


What is a scalar value in sql?

1014


What is linq to sql?

1061


what are the difference between clustered and a non-clustered index? : Sql dba

979


How do I run a program in pl sql?

952


what is a materialized view? : Sql dba

999


what is a tablespace? : Sql dba

1007


Explain the types of joins in sql?

966


What are sql*plus environment variables?

1032


Why use subqueries instead of joins?

1034


How do I kill a query in postgresql?

1014