Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 24021 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
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
How to create your own reports in sql developer?
Why having clause is used in sql?
Where the sql database files are stored?
What is schema in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
What is a nested table in word?
How do I trace sql profiler?
How do I clear the screen in sql plus?
What is sqlite format?
how can you see all indexes defined for a table? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
what are the t string functions available in tsql? : Transact sql
What are the types of records?
what is sql in mysql? : Sql dba
What is sql and explain its components?
