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
- 11444 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 is the difference between getdate and sysdatetime?
How do you test your database? : sql server database administration
What is acid properties?
Explain about unique identifier data type in sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are binary string data types in ms sql server?
How do I open port 1433?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to grant a permission in ms sql server using "grant execute" statements?
What is TDS(Tabular Data Stream) Gateway?
What is standby servers? Explain types of standby servers.
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
How to use column default values in insert statements in ms sql server?
How to reaname table name without using sp_Rename in sql server..?
Can we use pragma autonomous_transaction in trigger?
