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
- 11056 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
How can you hide the sql server instances?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What are synonyms?
Explain log shipping and mention its advantages.
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain different types of locks in sql server.
Is natural join and equi join same?
Why do we use stored procedures in sql server?
Explain system rowset functions?
What are difference between Cluster index and Non-Cluster index?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
what is unique and xaml nonclustered index
Define full outer join?
How to find out the list schema name and table name for the database?
How to modify existing triggers using "alter trigger"?
