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
Is delete faster than truncate?
What is use of term?
Is sql a backend?
What are different types of functions in sql?
What is the difference among union, minus and intersect?
How many commands are in sql?
Why do we use function in pl sql?
What is the maximum size of sqlite database?
What is difference between joins and union?
How many aggregate functions are available there in sql?
Is left join and outer join same?
how to fetch alternate records from a table? : Sql dba
How many unique keys can a table have?
Explain the steps needed to create the scheduled job?
what is bdb (berkeleydb)? : Sql dba