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
- 21429 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
What is the purpose of linked server configuration in sql server?
What is data set in report?
what are constraints? : Sql server database administration
What is the difference between Clustered and Non-Clustered Index?
What programming language would you use to create embedded functions in ssrs?
Find first and last day of current month in sql server
how to create a scrollable cursor with the scroll option? : Sql server database administration
How many primary keys are possible in a table?
Do you know what is sql injection?
How to transfer data from a cursor to variables with a "fetch" statement?
What is optimistic concurrency?
When a primary key constraint is included in a table, what other constraints does this imply?
What are data regions?
What are scalar functions in sql?
What is difference between views and tables?
