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
What is auto increment?
What is gpt format?
How does cross join work?
Why do we use sql constraints?
What program will open a mdb file?
What is a scalar value in sql?
What is linq to sql?
what are the difference between clustered and a non-clustered index? : Sql dba
How do I run a program in pl sql?
what is a materialized view? : Sql dba
what is a tablespace? : Sql dba
Explain the types of joins in sql?
What are sql*plus environment variables?
Why use subqueries instead of joins?
How do I kill a query in postgresql?