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
- 18015 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ved
EMPID=123 will show only one row....if you want to see multiple row then use EMPID IN (1,2,3)
Pratically Done.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
what are the different ways to return the rowcount of a table?
Can you explain the disadvantages/limitation of the cursor?
What are the restrictions applicable while creating views? : SQL Server Architecture
Can binary strings be used in arithmetical operations?
What is the default port for SQL Server over a firewall?
What is the purpose of the tempdb database?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Why I have to use stored procedures?
What is buffer cash and log cache in sql server?
How to create a scrollable cursor with the scroll option?
What do you mean by data integrity?
What is in place upgrade in sql server?
How to insert data into an existing table?
Can you move the resources after pausing the node? : sql server database administration
How to use transact-sql statements to access the database engine?
