Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8789 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
What is file based approach?
Define SQL and state the differences between SQL and other conventional programming Languages?
What is the difference between join and natural join?
Explain scalar functions in sql?
Which language is used in sql?
What is the process of copying data from table a to table b?
What is the use of sqlerrd 3?
What is sqlite format?
what is single byte over head in oracle..?
Which sql statement is used to delete data from a database?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is raw datatype in sql?
What is sap sql?
Why do we use procedures in pl sql?
