What is different between union and minus?
Answer Posted / pravin
Union combines the two table records, its eliminates
the duplicate records. while minus shows only those rows
which are not dulicated of table first in query.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what are the advantages of sql ? : Sql dba
What is record data type?
Can you call pl/sql package functions from within a fast formula?
Does asenumerable execute the query?
Does truncate release storage space?
What happens when a trigger is associated to a view?
How to sort the rows in sql.
What is normalization in a database?
What is a mutating table and a constraining table?
how to create a new view in mysql? : Sql dba
How do I view a table in sql?
List the ways to get the count of records in a table?
What is a function in oracle pl sql?
tell me about various levels of constraint. : Sql dba
State some properties of relational databases?