Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 9059 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / neha
In the in clause, the inner query is executed first, hence if the inner query return less data than the outer query, then use IN clause, in the other scenario, user exists clause.
Also, in the exists clause the inner query always reference outer query's table, which may or may not be the case with in IN clause.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Define SQL and state the differences between SQL and other conventional programming Languages?
What is the process of debugging?
explain the difference between delete , truncate and drop commands? : Sql dba
What is difference between nchar and nvarchar?
What is clause in sql?
How can triggers be used for the table auditing?
Does a user_objects view have an entry for a trigger?
How do you create a db file?
Is the primary key an index?
Does sql profiler affect performance?
How do I run sql profiler?
What is compound trigger?
What is audit logout in sql profiler?
What is mdb stand for?
how is exception handling handled in mysql? : Sql dba
