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
how to get help information from the server? : Sql dba
What is trigger explain with example?
What does the sign mean in sql?
What is foreign key sql?
Why we use triggers in mysql?
Is and as keyword in pl sql?
How do I clear the screen in sql plus?
What do you think about pl/sql?
what are properties of a transaction? : Sql dba
How to rename a column in the output of sql query?
How can triggers be used for the table auditing?
what is single byte over head in oracle..?
What is sql catalog?
Mention what are different methods to trace the pl/sql code?
What is a subquery in sql?