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
- 21885 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 are tables in sql server?
What is a transactions?
Can group functions be mixed with non-group selection fields in ms sql server?
Tell me what is de-normalization and what are some of the examples of it?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
how to create “alternate row colour”?
What is the purpose of the tempdb database?
how to create a scrollable cursor with the scroll option? : Sql server database administration
Do I need a report server to run reports in my application?
How to list all schemas in a database?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain datetimeoffset data type in sal server 2008?
What does it mean to be in union?
What is normalization? Explain different forms of normalization?
What are the types of sql server?
