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

What is trigger explain with example?

755


How do you take the union of two tables in sql?

734


What is the use of sqldataadapter?

704


What do you mean by field in sql?

787


What is foreign key sql?

748






What is procedure explain with example?

706


How can we avoid duplicating records in a query?

739


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

724


How to take user input in pl sql?

897


How do I add a database to sql?

779


How delete all data from all tables in sql?

690


What is indexing in sql and its types?

740


Can we use two order by clause in query?

738


What is the use of desc in sql?

698


What is having clause in sql?

715