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
- 17972 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / mohan
both are same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the features of Embedded SQL
Describe in brief system database.
Explain what is sql server english query?
Differentiate between delete and truncate.
What is the difference in accessing db between sql server vs sql azure?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is rs.exe utility?
How dts is used to extract, transform and consolidate data?
What is the sql profiler?
How to check parameter value in stored procedure sql server?
Can we use trigger new in before insert?
How to use subqueries with the exists operators in ms sql server?
How do database indexes work?
Explain the phases a transaction has to undergo?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
