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

What is different between union and minus?

Answer Posted / varma

union:
Union combines result set of two select statements
into one result set and from the result it eliminates
duplicate rows.

Minus:
Minus takes the result set of one select statement
and removes those rows that are also returned by another
select statement.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to get help information from the server? : Sql dba

919


What is trigger explain with example?

1016


What does the sign mean in sql?

967


What is foreign key sql?

973


Why we use triggers in mysql?

979


Is and as keyword in pl sql?

943


How do I clear the screen in sql plus?

1029


What do you think about pl/sql?

1002


what are properties of a transaction? : Sql dba

1077


How to rename a column in the output of sql query?

1064


How can triggers be used for the table auditing?

1049


what is single byte over head in oracle..?

2389


What is sql catalog?

1000


Mention what are different methods to trace the pl/sql code?

1178


What is a subquery in sql?

1022