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
- 21864 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / soumya ghosh
Both of them will return the same record
But as per the first sentence of the question, WHERE is a Clause whereas IN is a Operator. That is the difference between both.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How do I get to sql server configuration manager?
How to make conditional sum in ssrs?
What is a covering index?
What are translations and its use? : sql server analysis services, ssas
What are the transaction properties?
What is a derived table?
what is denormalization and when would you go for it? : Sql server database administration
Does sql server 2000 full-text search support clustering?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to use old values to define new values in update statements in ms sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
what is a join? : Sql server database administration
What are the advantages of the mirroring?
Which autogrowth database setting is good?
