Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between WHERE AND IN?
OR
1. SELECT * FROM EMPLOYEE WHERE EMPID=123
2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123)
WHAT IS THE DIFFERENCE?
- 15 Answers
- 20883 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / dinesh sharma
In WHERE Clause when the condition match no further scan of
table stop scanning the table after condition match.
where as IN operator It scan the full table either condition
match or not.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain how to use linked server?
what is a transaction? : Sql server database administration
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Do you know the capabilities of cursors?
Benefits of Stored Procedures?
What are “lock” hints?
how to use DTS package in 2000,2005,2008 in sql server
What do you mean by the term 'normalization'?
What is partitioned view?
what are the core components of SSRS?
Where are sql server usernames and passwords stored in the sql server?
Where do we use trace frag?
What will be query used to get the list of triggers in a database?
