Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 23739 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / ajinkyasingh bais
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without any duplicate rows.
whereas
The SQL MINUS clause/operator is used to combine two SELECT statements,but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How many types of triggers are there in pl sql?
What is meant by truncate in sql?
What are the datatypes available in pl/sql ?
Which language is used in sql?
How to use boolean type in select statement?
what are the advantages a stored procedure? : Sql dba
what are date and time functions in mysql? : Sql dba
What is a Mapplet?
Does sql view stored data?
how to decrement dates by 1 in mysql? : Sql dba
What is cartesian join in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
Why do we use set serveroutput on?
Why we use joins in sql?
What is an ndf file?
