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
- 10096 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
Explain trigger and its types?
How to set the current database in ms sql server?
What is indexing a document?
What are Spatial data types in SQL Server 2008
What is set nocount on and what is set nocount off?
What is sql server management studio? : sql server management studio
What is join query?
Which data type columns are the best candidates for full-text indexing?
How to view the error log for any specific instance? : sql server database administration
What do you mean by an execution plan?
What is resource db in sql server?
How to create a dynamic cursor with the dynamic option?
What is the full form of ddl?
What is intellisense?
What is acid properties?
