Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21430 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / saiteja
there is no difference among them.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Tell me what is log shipping?
How do I get to sql server configuration manager?
Why de-normalization required?
How to add code to the existing article (using improve article)?
Difference between DELETE and TRUNCATE?
What are the advantages of policy management?
What is the osql utility?
What is #temp and @table variable in SQL server?
what is create database syntax? : Sql server database administration
How many levels of sp nesting is possible?
Where in ms sql server is ’100’ equal to ‘0’?
What is normalization and what are the advantages of it?
If the job running very slow what is the action you do
What are the security related catalog views? : sql server security
What are the restraints imposed on the table design by a merge replication?
