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
- 10100 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
When you should use a low fill factor?
What is the cpu pressure?
How to see existing views in ms sql server?
What is normalization? Describe its different types.
What is the difference between executequery () and executeupdate ()?
What are the requirements on sql server network connections?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How raid can influence database performance?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to create an index on an existing table in ms sql server?
Can sql server 2016 run on windows 7?
What is the server name in sql server?
What the different components in replication and what is their use?
Can a table be created inside a trigger?
Where actually sql azure database is hosted?
