Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can you know that statistics should be updated?
What are the types of index in sql?
Can we create foreign key without primary key?
What is the max nvarchar size?
how to rename an existing column in a table? : Sql dba
How do I count rows in sql query?
Can we use join in subquery?
how to check myisam tables for errors? : Sql dba
Define a temp table?
what is rollback? : Sql dba
What are database links used for?
What is the difference between rename and alias?
What is a full join?
what are the different type of sql's statements ? : Sql dba
What is the difference between clustered and non-clustered index in sql?
