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
- 11266 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
What are the parts of a function?
Show Practically Sql Server Views are updatable?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Explain view in sql server?
Can we check locks in database? If so, how can we do this lock check?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
why would you call update statistics? : Sql server database administration
What are different types of database indexes?
Difference between DELETE and TRUNCATE?
What is catalog views?
What number aggregate functions are accessible there in sql?
What do you understand by replication in sql server?
How to create a view on an existing table in ms sql server?
Describe different Processing Modes offered by SSRS?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
