Interested to Buy Any Domain ? << Click Here >> for more details...
What is different between union and minus?
- 7 Answers
- 24018 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / ajinkyasingh bais
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without any duplicate rows.
whereas
The SQL MINUS clause/operator is used to combine two SELECT statements,but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How do I view a view in sql?
Enlist the characteristics of pl/sql?
Can you skip header records while loading? : aql loader
Define the select into statement.
How many types of triggers exist in pl/sql?
Which are the different case manipulation functions in sql?
What is the difference between having and a where in sql?
how many columns can be used for creating index? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
Can we enter data in a table in design view?
What are sql injection vulnerabilities?
Can we create foreign key without primary key?
Do foreign keys improve performance?
Is progress software supports to ( pl/sql )?
