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
Is foreign key mandatory?
how to fetch alternate records from a table? : Sql dba
How many triggers can be applied to a table?
What is difference between sql and mysql?
What is materialized view in sql?
How do you respond to dementia behavior?
What does trigger mean in psychology?
What are sql built in functions?
How do I run a script in sql developer?
What is self-join and what is the requirement of self-join?
Explain what is table in a database?
If a cursor is open, how can we find in a pl/sql block?
how many triggers are allowed in mysql table? : Sql dba
Why is nosql good?
Explain what is dbms?