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
- 18018 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vandana chand
where allows only single value in where Clause.
where as IN operator allwos multiple values in Where clause.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many databases can we create in a single server?
What is normalization of database? What are its benefits?
How to find tables without indexes?
Which is the latest version of sql server and when it is released?
Explain forward - only cursors?
What is cursors? And what are the different types of cursor?
List all the types of user-defined functions?
What is the osql utility?
When we should use @@error?
Why use “pivot” in sql server?
What are examples of triggers?
What is the difference between varchar and nvarchar datatypes?
How do I open port 1433?
What is exclusive locks?
Explain the concepts and capabilities of sql server?
