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
- 20863 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 candidate key with example?
Do you know the policy based administration feature of sql server 2008?
How to create a view with data from multiple tables?
How self join is different from outer join?
Do you know what is fill factor and pad index?
Explain about Normalization?
What is truncate table?
How to write a query with a left outer join in ms sql server?
What are ddl (data definition language) statements for tables in ms sql server?
How to execute function in stored procedure sql server?
Which tcp/ip port does sql server run on? How can it be changed?
What is acid properties?
How do you improve the performance of a SQL Azure Database?
What is normalization? Explain its different types?
What is subquery explain with example?
