Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 23387 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
Is sql dba a good career? : SQL DBA
Explain character-manipulation functions?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is varray in pl sql?
What is the purpose of normalization?
what is dbms? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
Can we use pl sql in sql server?
Are left and right joins the same?
What is the difference between left and left outer join?
What is nvarchar max in sql?
What is the difference between partition and index?
Does pdo prevent sql injection?
What is trigger price?
What view means?
