What is different between union and minus?
- 7 Answers
- 21679 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
What is the best sql course?
How to add a column ‘salary’ to a table employee_details?
What is cartesian join in sql?
How to use sql*plus built-in timers?
What is sql*plus?
How to return an array from java to pl/sql?
what is 'mysqlimport'? : Sql dba
What are different categories of sql commands?
What is string data type in sql?
Can a table contain multiple primary key’s?
Is it possible to create startup or shutdown trigger for on-schema?
What are the differences between implicit and explicit cursors?
What are the different datatypes available in PL/SQL?
What is sql exception?
What is sql injection vulnerability?
