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
- 21464 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 are the types of indexes?
How do you rename a table in sql server?
Mention the different types of triggers?
Explain what is log shipping?
How to use clusters?
Do you know the isolation level that sql server support?
What is the difference between SQL notification and SQL invalidation?
How can you find out which stored procedures are recompiling?
what is normalization? : Sql server database administration
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to execute multiple stored procedures at one time in sql server?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Which are the new data types introduced in sql server 2008?
What is a unique key constraint?
What is unpivot?
