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
- 11218 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 triggers?
What is table value parameters (tvp)?
How can I check if a view exists in a sql server database?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What are the restrictions that views have to follow?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What can be used instead of trigger?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain the difference between clustered and non-clustered index?
What are various limitations of the views?
How is a full-text index updated?
What are the advantages of sql azure?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is normalization? What number of normalization shapes are there?
What are temporal tables in sql server 2016?
