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
- 11264 Views
- ABC, Accenture, I also Faced
- E-Mail Answers
Answer Posted / manoj pandey
Check below links to know the reason with examples from my blog posts:
IN vs EXISTS vs JOIN: http://sqlwithmanoj.wordpress.com/2011/02/15/not-in-not-exists-joins-with-null-values/
UNION vs UNION ALL: http://sqlwithmanoj.wordpress.com/2010/12/30/why-union-all-is-faster-than-union/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are sql server procedures?
Can we add an identity column to decimal datatype?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to convert binary strings into integers in ms sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is table-valued sub query?
What is a field name?
What is normalization? Explain different forms of normalization?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to execute stored procedure and set temp table in sql server?
What is data modeling and Reterminal integrity?
Define clusters?
Explain query editor regions
Can you explain different types of locks in sql server?
How many types of the database links?
