Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 23747 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
Are subqueries faster than joins?
Is sql procedural language?
What is the use of sqlerrd 3?
What is a delimiter in sas?
Can we insert data in view?
What is meant by truncate in sql?
Why do we need databases?
Can we use insert statement in function?
Explain sql data types?
What is plpgsql language?
What is cursor in pl sql?
What are joins in sql?
Explain foreign key in sql?
Can you load data into multiple tables at once? : aql loader
What is dynamic sql in pl sql?
