Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between in and exists.
Ex: select * from emp where empno in(....) and
select * from emp where empno exists(....)
What is the difference between a Join and Union and Union
and UnionAll.
- 5 Answers
- 11051 Views
- ABC, Accenture, I also Faced
- E-Mail Answers
Answer Posted / saradhi
Just like JOINS, UNION combines data into a single record-
set but vertically by adding rows from another table. JOINS
combine data horizontally by adding columns from another
table.
UNION insures you get DISTINCT records from both the tables.
UNION ALL pulls out all records from both the tables with
duplicates.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
How can you ensure that the database and sql server based application perform well?
What is default constraint?
What happens to a trigger with multiple affected rows?
Do you know what are the ways available in sql server to execute sql statements?
What do you mean by a Composite primary key?
Can one drop a column from a table?
What are the components of dbms?
What is query processing?
Can You Use Data Mining Models In Ssrs?
Explain what is row_number function?
What are examples of triggers?
Explain system views?
Explain transaction server auto commit?
How to create a new table in a given schema?
