What is different between union and minus?
Answer Posted / varma
union:
Union combines result set of two select statements
into one result set and from the result it eliminates
duplicate rows.
Minus:
Minus takes the result set of one select statement
and removes those rows that are also returned by another
select statement.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the difference difference between procedure and packages
How do you create a db file?
What is sql used for?
Explain two easy sql optimizations.
How does one load ebcdic data? : aql loader
What is a heap in sql?
What is sql clause?
Is sql microsoft?
When is the update_statistics command used?
What is full join in sql?
What are instead of triggers?
How do I count duplicates in sql?
how can we know the count/number of elements of an array? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is pl/sql language case sensitive?