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 are the advantages of stored procedure?
What is the reports view in oracle sql developer?
Why are indexes and views important to an organization?
How many clustered indexes can you have?
How to start the command-line sql*plus?
Explain foreign key in sql?
What is the purpose of the sql select top clause?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What are types of exception?
In a distributed database system, can we execute two queries simultaneously?
What does (+) mean in sql joins?
How sql query is executed?
What is the difference between functions, procedures, and packages in pl/sql?
what is the difference between delete and truncate commands? : Sql dba
Is clustered index a primary key?