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
- 18016 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / guest
Here both is same but some situvations we want extact value
of one are more values then use in oprate
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we remove orphan records from a table?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Does partitioning ssd reduce performance?
What are different types of statements that are supported by sql?
What are commit and rollback in sql?
What does nvl stand for?
Where are stored procedures in sql server?
How can sql injection be stopped? : sql server security
What is the purpose of the tempdb database?
what is a deadlock? : Sql server database administration
Explain the steps needed to create a scheduled job?
What are drilldown reports?
What is sql or structured query language?
What encryption security is available in sql azure?
