Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between IN and EXISTS.which one is
faster.
- 3 Answers
- 8924 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 database sql?
What does where 1 1 mean in sql?
Can we change the table name in sql?
Are pl sql variables case sensitive?
What is data manipulation language?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is the usage of sql functions?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Where is pl sql used?
What is the difference among union, minus and intersect?
Does sql*plus have a pl/sql engine?
What are the ddl commands?
Explain how to use transactions efficiently : transact sql
What do you mean by “trigger” in sql?
Why are indexes and views important to an organization?
