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
- 11284 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 scalar functions?
How to change server name in sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
what do you understand by change data capture?
Where views are stored in sql server?
Can you explain powershell included in sql server 2008?
How to add an address record into adventureworkslt?
Can we store videos inside the sql server table?
Tell me what is difference between clustered and non clustered index?
What happens if you add a new index to large table?
What is role playing dimension with two examples? : sql server analysis services, ssas
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How to create a simple stored procedure in ms sql server?
What is raid? : SQL Server Architecture
How to return the date part only from a sql server datetime datatype?
