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
- 21865 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
What is blocking?
Explain about integration services of Microsoft SQL server?
What are the authentication modes in sql server? How can it be changed?
How do I find the port number for sql server?
How to replace given values with null using nullif()?
Tell me what is difference between clustered and non clustered index?
Do you know what is blocking?
What do you mean by stored techniques? How would we use it?
What is the difference between set and select?
When would you use the stored procedures or functions?
What are trace flags?
What do you understand by triggers and mention the different types of it?
Explain the Ways to improve the performance of a sql azure database?
How to add a new dsn with the odbc driver for sql server?
Explain the use of keyword with encryption. Create a store procedure with encryption?
