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 difference between clustered and a non-clustered index? : Sql dba
Explain commit, rollback and savepoint.
What are the three forms of normalization?
What is nvarchar in sql?
Cite the differences between execution of triggers and stored procedures?
what is single byte over head in oracle..?
What is oracle pl sql developer?
What is audit logout in sql profiler?
what is the difference between cluster and non cluster index? : Sql dba
Is progress software supports to ( pl/sql )?
What are the advantages of pl sql?
What is rownum?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What are pl/sql cursors?
how mysql optimizes distinct? : Sql dba