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
- 11055 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
which backup strategy you are following at ur company
Disadvantages of the indexes?
explain the storage models of olap? : Sql server database administration
Write a program using SQL queries to find a unique entry in a table.
Explain “not null constraint” in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Where cross join is used?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is a mixed extent?
How do you size a resultset?
Do you know the capabilities of cursors?
What are types of subqueries?
How to modify an existing user defined function?
What is the index requirement in SQL Azure?
What is the process of indexing?
