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
- 19448 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / aditya bisoi
Actually Both Query will return Same Result....
But Performance wise 1st Query better..Bcz it will return the Exact Record with out check hole record in the table....
But when we use IN operator then the sql engine will do the Table scan and retrive the Result...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is the order by used for?
what data regions are and what are the different data regions?
What security features are available for stored procedure?
What is the server name for sql management studio?
How do you manipulate data?
Why do you need a sql server?
What is history table in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain the use of containers in ssis and also their types?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is ssrs?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Explain what is “asynchronous” communication in sql server service broker?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
