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
- 11280 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 are the reporting services components?
Define inner join in sql server joins?
What is multi-statement table-value user-defined function?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is the command used to recompile the stored procedure at run time?
What is tablix?
What are the advantages of user defined function?
What are the pre-defined functions in the sql server?
What do you mean by a Composite primary key?
List some of the rules that apply to creating and using a ‘view’
What does truncate do?
What is repeatable read?
What is sql server agent and what are the two modes of authentication in sql server?
How to generate create function script on an existing function?
What is difference between views and tables?
