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
- 10098 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
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to find table changes in sql server?
What happens when converting big values to numeric data types?
how you can list all the tables in a database?
How much is a sql server license?
Name 3 ways to get an accurate count of the number of records in a table?
What are cursors stored procedures and triggers?
Why do we use non clustered index?
Can you explain different types of locks in sql server?
How is foreign key related to primary key?
How to create a dml trigger using create trigger statements?
How to backup SQL Server Reporting Services ?
Is there any difference between primary key and unique with the not null condition?
What are the types of joins in sql?
What is the purpose of grouping data in a report?
