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.
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 types of scd? : sql server analysis services, ssas
How to assign null values to variables or columns?
Do you think BCNF is better than 2NF & 3NF? Why?
Where views are stored in sql server?
Define views.
How to receive returning result from a query?
Tell me what is the order in which the sql query is executed?
What is the usage of the sign function?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is sql server profiler trace data file?
How to find related tables in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain user defined functions?
What is the use of @@spid?
Tell me what is the difference between locking and multi-versioning?