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.
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 differences between having and where clause.
tell me the disaster recovery plan
What is the architecture of ms sql reporting service?
What is the difference between for xml raw and for xml auto?
Which is the main third-party tool used in sql server?
Explain nested join?
What is best institute to Learn DotNET And SQL in chennai?
How to delete existing triggers using "drop trigger"?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Do you know what is lock escalation?
How can we improve performance by using SQL Server profiler?
How to find out what is the default collation in a database?
Name and describe few console utilities for ssrs?
Describe different Processing Modes offered by SSRS?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration