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
- 19408 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / mohan
both are same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use max in where clause?
What is the use of stored procedure?
How many cores do I need for sql server 2016?
What are the differences between char and nchar in ms sql server?
How to modify the underlying query of an existing view?
How to delete a login name in ms sql server?
Name 3 ways to get an accurate count of the number of records in a table?
What should be the fill factor for indexes created on tables? : sql server database administration
What do you mean by data integrity?
How to invoke a trigger on demand?
between cast and convert which function would you prefer and why?
Disadvantages of the indexes?
Explain intellisense for query editing
Do you know query execution plan?
What is the default value of an integer data type in sql server 2005?
