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
What is trigger explain with example?
How do you take the union of two tables in sql?
What is the use of sqldataadapter?
What do you mean by field in sql?
What is foreign key sql?
What is procedure explain with example?
How can we avoid duplicating records in a query?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How to take user input in pl sql?
How do I add a database to sql?
How delete all data from all tables in sql?
What is indexing in sql and its types?
Can we use two order by clause in query?
What is the use of desc in sql?
What is having clause in sql?