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 nosql relational?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is sql profiling in oracle?
How to read xml file in oracle pl sql?
Can we insert in sql function?
What is difference between pl and sql?
What is procedure in pl sql?
How many types of triggers are there in pl sql?
Explain polymorphism in pl/sql.
Explain constraints in sql?
Is join and inner join the same?
What are the disadvantages of file system?
How do I remove all records from a table?
How to display the current date in sql?
Can we debug stored procedure?