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
- 19403 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / chandan
IN operator is used to specify multiple variable.
while in this query both result will be same.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Write a query to find 5th highest amount paid from the customer table.
what are the different types of SSRS reports?
What is autocommit mode in sql server?
How many types of schemas are there?
Do you know what are the properties of the relational tables?
Do you know the capabilities of cursors?
Can binary strings be used in arithmetical operations?
How to drop an existing user defined function in ms sql server?
When is the use of update_statistics command?
what is bit datatype? : Sql server database administration
Do you have any idea about the tcl commands?
What is the difference between seek predicate and predicate?
How to copy the tables, schema and views from one sql server to another?
List all the types of user-defined functions?
What are the different sql server versions?
