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
- 17968 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / abinash
Jaipal Sing: Lets say I will keep only one value (123) in IN
clause. In this case what is the real difference??
This is how Question asked to me!! and I am answer less...
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain the database you used in your final year project?
How to create database with physical files specified in ms sql server?
What happens if null values are involved in bitwise operations?
Does a full backup include transaction log?
What is the data tier application?
What is the Control Flow in SSIS
What is 'write-ahead log' in sql server 2000 ?
Can select statements be used on views in ms sql server?
Explain what is lock escalation and what is its purpose?
What is sub-query in sql server? Explain its properties.
Explain about temporary stored procedure?
What are the difference between primary key and unique key? : sql server database administration
How to drop an existing user defined function in ms sql server?
what is a join and explain different types of joins? : Sql server database administration
What are different replication agents and what's their purpose? : sql server replication
