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
- 18060 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
what is a check constraint?
What does <> symbol mean?
How to turn off warning messages during php execution?
What are the different types of upgrades that can be performed in sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is exclusive locks?
Mention the differences between substr and charindex in sql server.
What is the current limitation of the size of SQL Azure DB?
explain different types of joins? : Sql server database administration
What is a non equi join?
Explain what is dbcc?
Show Practically Sql Server Views are updatable?
Explain four layers of abstraction microsoft architectured?
What is the dbcc command and why is it used?
How to delete duplicate rows in sql server?
