Answer Posted / pavan_1981
UNION:set of all rows selected by both queries excluding
duplicates rows.
UNIONALL:set of all rows selected by both queries including
duplicate rows.
MINUS:set of all rows present in the first query and not
present in the second query.
INTERSECT:set of all rows commonly returned by both the
queries.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
Explain the rollback statement?
how to do backup entire database? : Transact sql
What is the basic structure of an sql?
Which is faster view or stored procedure?
How subquery works in sql?
what is subquery? : Sql dba
Does access use sql?
what are the advantages and disadvantages of views in a database? : Sql dba
How many primary keys can a table have?
what is a composite key ? : Sql dba
What is composite data type in pl sql?
What is the difference between execution of triggers and stored procedures?
What is the use of partition by in sql?
What is trigger types of trigger?
Explain scalar functions in sql?
