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
- 11274 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 is SQL Azure Data sync?
What is the difference between function and stored procedure in sql server?
What do you mean by data integrity?
What area unit the various kinds of info compression introduced in sql server 2008?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain different types of collation sensitivity?
How to delete existing rows in a table?
what is the different types of backups available in sql server? : Sql server database administration
What will be the maximum number of indexes per table?
What is the purpose of sql profiler in sql server? : sql server database administration
What is the process of normalising?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What are the Advantages of using CTE in sql server?
Explain why variables called the most powerful component of ssis?
