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
- 11442 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 the pros and cons of putting a scalar function in a queries select list or in the where clause?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Tell me what is difference between clustered and non clustered index?
What are constraints in microsoft sql server?
Explain the properties of the relational tables?
How to write a query with a right outer join in ms sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is the difference between lock, block and deadlock? : sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
How will you know when statistics on a table are obsolete?
What are the differences between ms sql server & oracle?
Explain cdc and sql injection?
explain how to create a new schema in a database? : Sql server database administration
What are the purposes and advantages stored procedure?
