Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 23631 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 stuff function and how does it differ from the replace function? : Sql dba
what is bdb (berkeleydb)? : Sql dba
Which is faster union or join?
Can we use update in sql function?
How do I view an execution plan in sql?
What is auto increment feature in sql?
What will you get by the cursor attribute sql%found?
What is row_number () in sql?
What is difference between stored function and application function?
Can we use the cursor's to create the collection in PL/SQL?
Why is sql important?
What is the difference between python and sql?
How to load data with sql*loader?
What is primary key and foreign key with example?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
