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
- 9761 Views
- ABC, Accenture, I also Faced
- E-Mail Answers
Answer Posted / shafiq...
When you use IN operator it will scan all the row in table
to check and Exists means when its find the data stop
execute to check further row.
Join- to join matching data from two or more table.
Union- Retrive matching data from both table.
UnionAll- Retrive matching as well as unmatched data from
both data.
hope this is clear
| Is This Answer Correct ? | 19 Yes | 6 No |
Post New Answer View All Answers
Explain the difference between functions and stored procedures in sql server?
How do you rebuild an identity column?
Explain what you mean by 3 tier architecture.
explain what is raid and what are different types of raid configurations? : Sql server database administration
Which is faster statement or preparedstatement?
What is the recursive stored procedure in sql server?
What is the name of reporting services config file and what’s it’s used for?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is NOT NULL Constraint in sql server 2012?
How to modify the underlying query of an existing view?
Do you know what is sql injection?
How to encrypt Strored Procedure in SQL SERVER?
What are various aggregate functions that are available?
Detail about query optimizer?
How to filter out duplications in the returning rows in ms sql server?
