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 / humayun quaiser


unoin:- This operator returns from all the queries(combined
through union) but not duplicate record will be display.
ex- A={1,2,3,4}
B={2,3,4,5}
AUB={1,2,3,4,5}............

Minus:- This operator displays records which belongs to only
the first query.
ex:- A={1,2,3,4}
B= {2,3,5}
A-B={1,4}...................

Is This Answer Correct ?    24 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is nosql relational?

892


Could you please provide oca (oracle 10g) dumps for my certification ?

5070


What is sql profiling in oracle?

995


How to read xml file in oracle pl sql?

859


Can we insert in sql function?

1025


What is difference between pl and sql?

992


What is procedure in pl sql?

978


How many types of triggers are there in pl sql?

1011


Explain polymorphism in pl/sql.

1055


Explain constraints in sql?

980


Is join and inner join the same?

940


What are the disadvantages of file system?

1163


How do I remove all records from a table?

1023


How to display the current date in sql?

1008


Can we debug stored procedure?

956